UPDATE order_abnormal_audit au SET au.service_user_id =
IFNULL((SELECT o.service_user_id FROM `order` o WHERE o.id = au.order_id),0)
mysql修改某字段，设置字段值=关联表的值
UPDATE order_abnormal_audit au SET au.service_user_id =
IFNULL((SELECT o.service_user_id FROM `order` o WHERE o.id = au.order_id),0)
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
