SQLServer中的update……from语句用于更新替换表中的某些行,例如
update NewTable set Name = B.Name
from NewTable A,NewTable_Copy B
where A.ID = B.ID
而在mysql中需要改成如下写法
update NewTable,NewTable_Copy
set NewTable.`Name` = NewTable_Copy.`Name`
where NewTable.`ID` = NewTable_Copy.`ID`