CASE WHEN 语句进行字符串替换处理代码,MYSQL代码库,德仔网

代码语言

代码分类

【MYSQL】 CASE WHEN 语句进行字符串替换处理

作者:晨曦 / 发布于2017/3/9/ 748

Drop table sales;  
    
CREATE TABLE sales(  
    num MEDIUMINT NOT NULL AUTO_INCREMENT,  
    name CHAR(20),  
    winter INT,  
    spring INT,  
    summer INT,  
    fall INT,  
    category CHAR(13),  
    primary key(num)  
)type=MyISAM;  
  
insert into sales value(1, 'Java', 1067 , 200, 150, 267,'Holiday');  
insert into sales value(2, 'C',970,770,531,486,'Profession');  
insert into sales value(3, 'JavaScript',53,13,21,856,'Literary');  
insert into sales value(4, 'SQL',782,357,168,250,'Profession');  
insert into sales value(5, 'Oracle',589,795,367,284,'Holiday');  
insert into sales value(6, 'MySQL',953,582,336,489,'Literary');  
insert into sales value(7, 'Cplus',752,657,259,478,'Literary');  
insert into sales value(8, 'Python',67,23,83,543,'Holiday');  
insert into sales value(9, 'PHP',673,48,625,52,'Profession');  
select * from sales;  
  
SELECT name AS Name,  
CASE category  
WHEN "Holiday" THEN "Seasonal"  
WHEN "Profession" THEN "Bi_annual"  
WHEN "Literary" THEN "Random" END AS "Pattern"  
FROM sales;

试试其它关键字

同语言下

可能有用的

晨曦贡献的其它代码(11)