《Mysql必读MySQL的CASE WHEN语句的几个使用实例》要点:
本文介绍了Mysql必读MySQL的CASE WHEN语句的几个使用实例,希望对您有用。如果有疑问,可以联系我们。
MYSQL数据库使用CASE WHEN进行字符串替换处置
MYSQL数据库9 rows in set (0.01 sec)
MYSQL数据库SELECT name AS Name,
CASE category
WHEN "Holiday" THEN "Seasonal"
WHEN "Profession" THEN "Bi_annual"
WHEN "Literary" THEN "Random" END AS "Pattern"
FROM sales;
MYSQL数据库9 rows in set (0.00 sec)
MYSQL数据库CREATE TABLE sales(
num MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(20), winter INT, spring INT,
su妹妹er INT, fall INT, category CHAR(13), primary key(num)
) ENGINE=MyISAM;
MYSQL数据库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');
MYSQL数据库8 rows in set (0.01 sec)
欢迎参与《Mysql必读MySQL的CASE WHEN语句的几个使用实例》讨论,分享您的想法,维易PHP学院为您提供专业教程。