Difference in syntax when MySQL and ms SQL Server databases use multi-table join update

From: http://hi.baidu.com/shallinyao/blog/item/a3b894cf925a3e0b92457e91.html

 

 

We often encounter the need to batch update the values of some fields in one table to the corresponding fields in the corresponding records of another table.

Syntax for ms SQL SERVER: Update T1 set t1.tvalue = t2.tvaluefrom t1inner join T2 on t1.id = t2.id example: Update areaset area_phone_code = z. codefrom areainner join test.zip code Zon Z. areaid =. area_codemysql Syntax: Update Table1 T1, Table2 T2 set t1.tvalue = t2.tvalue where t1.id = t2.id example: Update Area A, test.zip code zset. area_phone_code = z. codewhere Z. areaid =. area_code databases differ greatly in this syntax.