UPDATE t_business_opportunity t1, (select t2.id,t3.user_id from t_business_opportunity t2 left join sys_user t3 on t2.create_by=t3.user_name) as t4 SET t1.create_by = t4.user_id where t1.id=t4.id;
修改带查询条件处理
原文：https://www.cnblogs.com/ff2ting/p/15194851.html
