修改bbb表name字段为,关联查询的sss表的name字段
UPDATE bbb(表1) AS b
INNER JOIN eee(表2) e ON b.eid = e.id
INNER JOIN sss(表3 ) s ON e.sid = s.id
SET b.name=s.name
修改bbb表name字段为,关联查询的sss表的name字段
UPDATE bbb(表1) AS b
INNER JOIN eee(表2) e ON b.eid = e.id
INNER JOIN sss(表3 ) s ON e.sid = s.id
SET b.name=s.name