update
test_ins_user t1,
(
SELECT
test_ins_user_mess.create_by,
test_ins_user.user_name
FROM
test_ins_user
left join test_ins_user_mess on test_ins_user_mess.user_name = test_ins_user.user_name
) t2 set t1.create_by = t2.create_by where t1.user_name = t2.user_name;
MySQL数据批量更新操作
最新推荐文章于 2023-01-03 16:05:11 发布