扫码关注官方订阅号
闭关修行中......
UPDATE yw_tmp_usr a, yhdang b SET a.hth = b.hth WHERE a.business_key=b.dh
UPDATE yw_tmp_usr SET hth = T.hth
FROM (
SELECT hth, dh FROM yhdang
) T
WHERE yw_tmp_usr.business_key = T.dh
微信扫码关注PHP中文网服务号
QQ扫码加入技术交流群
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
PHP学习
技术支持
返回顶部
0 
2
504
收藏
UPDATE yw_tmp_usr a, yhdang b SET a.hth = b.hth WHERE a.business_key=b.dhUPDATE yw_tmp_usr SET hth = T.hth
FROM (
) T
WHERE yw_tmp_usr.business_key = T.dh