MySQL数据批量更新操作

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;