【小白SQL】mysql update 单表多字段left join 语句
UPDATE table_1 t1 left join table_2 t2 on t2.id = t1.tid left join table_3 t3 on t2.id = t3.t_id SET t1.username = t2.uname ,t1.number = t3.num ,t1.userphone = t3.mobile where t1.id>5;如果有更多的表需要关联可以多写几行left join ,需要更新更多的字段,可以在set后面用逗号隔开。...
原创
2021-06-21 22:56:25 ·
826 阅读 ·
0 评论