SQL> select * from a; A1
----------
1
1
2SQL> select * from b; B1 B2
---------- ----------
1 5
2 8SQL> update a set a1=(select b2 from b where b1=a.a1);3 rows updated.SQL> select * from a; A1
----------
5
5
8
----------
1
1
2SQL> select * from b; B1 B2
---------- ----------
1 5
2 8SQL> update a set a1=(select b2 from b where b1=a.a1);3 rows updated.SQL> select * from a; A1
----------
5
5
8
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货