根据一个表更新另一个表的内容

 

sql

update Table1

set Table1.co1=Table2.co1,

       Table1.co2=Table2.co2

from Table2

where Table2.id=Table1.id

 

 

mysql

 

 

update student s, city c

   set s.city_name = c.name



 where s.city_code = c.code;