MySQL多表更新

UPDATE A
JOIN B ON A.id = B.id
SET A.`name` = "sky",
 B.`name` = "andy";