批量更新sql |批量update sql
图所示
现
需要批量更新table2表内字段Pwd
更新
userName对
IP地址
username与Ip对应关系
table1所示
update table2 set pwd=table1.ip from table1 inner join table2 on table1.username=table2.username
UPDATE TABLE2 A SET A.PWD =(SELECT B.IP FROM TABLE1 B WHERE B.userName =A.userName)
