(后端)根据查询语句修改的update语句

UPDATE A SET a.name = m.name
FROM item  A
INNER JOIN table M ON A.id=M.id
WHERE a.xx <> M.xx
原文地址:https://www.cnblogs.com/historylyt/p/9259350.html