单字段更新 -- 更新字段1 UPDATE table_b SET field_1 = (SELECT field_1 FROM table_a WHERE id = table_b .id); -- 更新字段1和字段2 UPDATE table_b AS b LEFT JOIN table_a AS a ON b.id= a.id SET b.field_1 = a.field_1 , b.field_2 = a.field_2 ;