sql 语句求解
答案:2 悬赏:50 手机版
解决时间 2021-11-24 01:59
- 提问者网友：王者佥
- 2021-11-23 08:50
sql 语句求解
最佳答案
- 五星知识达人网友：廢物販賣機
- 2021-11-23 10:12
用下面的sql，测试结果附图
insert into test
(select
(test_id+100) as test_id,
test_type,
(concat(test_name,"_st")) as test_name,
case when test_vl1 > 0 then test_vl1+200 ELSE test_vl1 end as test_vl1,
case when test_vl2 > 0 then test_vl2+200 ELSE test_vl2 end as test_vl2,
test_vl3
from test as t
where test_type > 0);
insert into test
(select
(test_id+100) as test_id,
test_type,
(concat(test_name,"_st")) as test_name,
case when test_vl1 > 0 then test_vl1+200 ELSE test_vl1 end as test_vl1,
case when test_vl2 > 0 then test_vl2+200 ELSE test_vl2 end as test_vl2,
test_vl3
from test as t
where test_type > 0);
全部回答
- 1楼网友：罪歌
- 2021-11-23 11:46
UPDATE #TABLESET STATUS=1WHERe ID IN ("1","2","3","4")
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯