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修改某字段,设置字段值=关联表的值
最新推荐文章于 2024-07-22 17:39:53 发布
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)