update left join 多表关联更新 

UPDATE table_1 t1 left join table_2 t2 on t2.id = t1.tid SET t1.username = t2.uname
where t1.id>5;

 

posted @ 2021-01-11 13:26  关键步就几步  阅读(2553)  评论(0)  编辑  收藏  举报