用一条sql语句修改三个地方
答案:6 悬赏:70
解决时间 2021-04-27 12:15
- 提问者网友:喵星人荷西
- 2021-04-27 02:55
有表Demo 字段有id和name,name值有九条,怎样用一条语把name属性中的前三条值改成A,中间三条改成B,最后三条改成C
最佳答案
- 二级知识专家网友:我颠覆世界
- 2021-04-27 04:02
update all Demo when case id<4 then set name='A ' when case id<7 then set name='B' when case id<10 then set name='C'
全部回答
- 1楼网友:初心未变
- 2021-04-27 07:59
楼上的不对吧!你们就确认前9条的id就是1-9,太主观了。
- 2楼网友:承载所有颓废
- 2021-04-27 07:37
update Demo set id=case when id<4 then 'A' when id>3 and id<7 then 'B' else 'C' end
- 3楼网友:茫然不知崩溃
- 2021-04-27 07:08
UPDATE DEMO SET NAME='A' WHERe ID<=3 UPDATE DEMO SET NAME='B' WHERe ID<=6 AND ID>3 UPDATE DEMO SET NAME='C' WHERe ID<=9 AND ID>6
- 4楼网友:废途浑身病态
- 2021-04-27 05:56
update tablea set tablea.name=b.name from tablea a, ( select id, 'a' as name from tablea where id between 1 and 3 union select id, 'b' as name from tablea where id between 50 and 60 union select id, 'c' as name from tablea where id between 80 and 85
) b where a.id=b.id
- 5楼网友:哭不代表软弱
- 2021-04-27 04:39
--sql server
update demo set [name]='C'
SET ROWCOUNT 6
update demo set [name]='B'
SET ROWCOUNT 3
update demo set [name]='A'
SET ROWCOUNT 0
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯