踩坑update set

mysql 与 sqlserver中 update set 语法有些差异

sqlserver

UPDATE tableA
SET columnA=tableB.columnB
FROM
(SELECT columnB FROM tableB WHERE ...)
WHERE 

…

mysql

UPDATE
    tableA
    INNER JOIN
    tableB ON  columnA = columnB    
SET
    columnC = columnD