sql 语句求解
sql 语句求解
日期:2017-10-26 09:44:50 人气:1
用下面的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 tes