MySQL 和 SQLSERVER不一样,update set from 一张表的时候 应该改为
UPDATE TABLE_AA INNER JOIN TABLE_BB ON TABLE_AA.ID = TABLE_BB.ID SET NAME = TABLE_BB.NAME
2022-11-23 13:11:19
MySQL 和 SQLSERVER不一样,update set from 一张表的时候 应该改为
UPDATE TABLE_AA INNER JOIN TABLE_BB ON TABLE_AA.ID = TABLE_BB.ID SET NAME = TABLE_BB.NAME