34,594
社区成员
发帖
与我相关
我的任务
分享关于 Update 语句
update table1 (col1,col2,col3)
select col1,col2,col3 from table2 where id = 1
如何实现，反正我知道这样不对.
select col1,col2,col3 from table2 where id = 1
如何实现，反正我知道这样不对.
...全文
请发表友善的回复…
发表回复
zjcxc 元老 2004-09-02
- 打赏
- 举报
update a set col1=b.col1,col2=b.col2,col3=b.col3
from table1,(select col1,col2,col3 from table2 where id = 1)b
where a.id=1 --如果只是更新 table1中与table2 id相同的
from table1,(select col1,col2,col3 from table2 where id = 1)b
where a.id=1 --如果只是更新 table1中与table2 id相同的
老宛 2004-09-02
- 打赏
- 举报
早知道我就不打那几个字了，同时发出呀
老宛 2004-09-02
- 打赏
- 举报
你那个格式是insert的格式，呵呵
update a set a.col1=b.col1,a.col2=b.col2,a.col3=b.col3
from table1 a,table2 b where a.id=b.id and a.id=1
update a set a.col1=b.col1,a.col2=b.col2,a.col3=b.col3
from table1 a,table2 b where a.id=b.id and a.id=1
yesterday2000 2004-09-02
- 打赏
- 举报
UPDATE table1 SET COL1=B.COL1,COL2=B.COL2,COL3=COL3 FROM TABLE1 A,TABLE 2 B WHERE A.ID=B.ID AND B.ID=1
skyboy0720 2004-09-02
- 打赏
- 举报
update table1 set col1=(select col1 from table2 where id = 1)
,col2=(select col1 from table2 where id = 1)
,col3=(select col1 from table2 where id = 1)
,col2=(select col1 from table2 where id = 1)
,col3=(select col1 from table2 where id = 1)
zjcxc 元老 2004-09-02
- 打赏
- 举报
update a set col1=b.col1,col2=b.col2,col3=b.col3
from table1,(select col1,col2,col3 from table2 where id = 1)b
from table1,(select col1,col2,col3 from table2 where id = 1)b
