34,576
社区成员
发帖
与我相关
我的任务
分享怎么把表中满足一定条件的记录的某个列改为某个定值？
如何把a表中 class=1的所有学生的State都改为'UOA'
下面这么做通不过
select State='UOA'
from A
where class=1
下面这么做通不过
select State='UOA'
from A
where class=1
...全文
请发表友善的回复…
发表回复
ysycrazy 2003-10-20
- 打赏
- 举报
update a
set state='UOA'
where class=1
set state='UOA'
where class=1
伍子V5 2003-10-20
- 打赏
- 举报
update a set state='UOA' where class=1
或则
select (case when class=1 then 'UOA' else state end) as State from a
或则
select (case when class=1 then 'UOA' else state end) as State from a
txlicenhe 2003-10-20
- 打赏
- 举报
update a set state='UOA' where class=1
yujohny 2003-10-20
- 打赏
- 举报
update a
set state='UOA'
where class=1
set state='UOA'
where class=1
