2020-11-02 mysql更新一张表的字段来自另一张表的某个字段

UPDATE tba a LEFT JOIN tbb b on a.id=b.id set a.name = b.name where a.id = b.id

create database test default character set utf8mb4 collate utf8mb4_general_ci;