UPDATE tba a LEFT JOIN tbb b on a.id=b.id set a.xxx = b.xxxx where a.id = b.id
mysql更新一张表的字段来自另一张表的某个字段
最新推荐文章于 2023-03-21 09:26:51 发布
UPDATE tba a LEFT JOIN tbb b on a.id=b.id set a.xxx = b.xxxx where a.id = b.id