有两个表 \
table1:
ID Name
-------------------
1 aa
1 bb
2 cc
3 dd
4 ee
5 aa
...................table2sID sName
-------------------
aa
bb
cc
ee
aa
...................现在要更新表table2
结果如下
sID sName
-------------------
1 aa
1 bb
2 cc
4 ee
1 aa
.............
table1:
ID Name
-------------------
1 aa
1 bb
2 cc
3 dd
4 ee
5 aa
...................table2sID sName
-------------------
aa
bb
cc
ee
aa
...................现在要更新表table2
结果如下
sID sName
-------------------
1 aa
1 bb
2 cc
4 ee
1 aa
.............
WHERE EXISTS(SELECT ID FROM TABLE1 WHERE TABLE1.NAME=TABLE2.NAME);
union select 1,'bb'
union select 2,'cc'
union select 3,'dd'
union select 4,'ee'insert into table2 select NULL,'aa'
union select NULL,'bb'
union select NULL,'cc'
union select NULL,'ee'
union select NULL,'aa'
update table2 set SID=ID
from table1,table2
where table1.Name=table2.SNameselect * from table21 aa
1 bb
2 cc
1 aa
4 ee