update join 的使用 多表的条件修改 UPDATE table_a AS a ( INNER ) JOIN table_b AS b ON a.id = b.a_id SET a.age = 10 WHERE b.id = 1 AND a.NAME = "hanyi" - 也可以通过隐式连接 达到接连多表修改的操作,效果相同 UPDATE table_a , table_b AS b SET a.age = 10 WHERE AND a.id = b.a_id b.id = 1 AND a.NAME = "hanyi"