mysql 复杂 update 语句

2020-04-27 本文已影响0人小蓝田

mysql update 关联其他表更新数据

UPDATE tableB t1
INNER JOIN tableA t2 ON t1.id = t2.id 
SET t1.NAME = t2.NAME 
WHERE
    t2.NAME = 'Joe';

UPDATE tableB t1
INNER JOIN tableA t2 INNER JOIN tableC t3 ON t1.id = t2.id AND t2.name=t3.name
SET t1.NAME = t2.NAME 
WHERE
    t2.NAME = 'Joe';