(1)update基本使用
update 表 set 字段1 = '值1' where 字段2='值2'
(2)update在一个表中更新的情况,如图所示:
![](http://upload-images.jianshu.io/upload_images/3436003-52e71b729cb348e7.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
我想在ID=3出现时修改ID=2的字段3
update 表 set 字段3 ='值' where ID =(select 来源ID from 表 where ID = '3')
(3)update多表关联的情况
![](http://upload-images.jianshu.io/upload_images/3436003-003a8a2fcf593428.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
1
![](http://upload-images.jianshu.io/upload_images/3436003-3dee0437c4af1cf4.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
2
根据id,将表1的name填入到表2的Cname中
【1】UPDATE test2 SET Cname = test1.name FROM test1 WHERE test2.id = test1.id
【2】UPDATE test2 SET Cname = test1.name FROM test1 WHERE test1.id = test2.id
【3】UPDATE test2 SET Cname = test1.name FROM test1,test2 WHERE test2.id = test1.id
以上3中方法都可以
但是
UPDATE test2 SET Cname = test1.name FROM test2 WHERE test1.id = test2.id
此语句不正确
PS:有了新的使用方法,或者我用到了我会及时更新的~~~~