update 语句:从一个表中更新另一个表的字段

update table_all a set a.phoneNo=b.phoneNo from table_new b where a.name =b.name

update table_all set table_all.phoneNo = (select table_new.phoneNo from table_new where table_all.name = table_new.name)

8 thoughts on “update 语句:从一个表中更新另一个表的字段

  1. Pingback: taipanqq

  2. Pingback: Offshore Company Formation

  3. Pingback: เงินด่วน

  4. Pingback: 188bet

  5. Pingback: Watch A Simple Favor Free Online

  6. Pingback: ไวอากร้า

  7. Pingback: http://apartamentynaibizie.pl/

  8. Pingback: Ivana Nadal

Comments are closed.