Mysql必读MySQL的CASE WHEN语句的几个使用实例

发布时间：2020-12-12 02:52:45 所属栏目：MySql教程来源：网络整理

导读：《Mysql必读MySQL的CASE WHEN语句的几个使用实例》要点：本文介绍了Mysql必读MySQL的CASE WHEN语句的几个使用实例，希望对您有用。如果有疑问，可以联系我们。 MYSQL数据库使用CASE WHEN进行字符串替换处置代码以下:mysql select * from sales; MYSQL数据

《Mysql必读MySQL的CASE WHEN语句的几个使用实例》要点：
本文介绍了Mysql必读MySQL的CASE WHEN语句的几个使用实例，希望对您有用。如果有疑问，可以联系我们。

MYSQL数据库使用CASE WHEN进行字符串替换处置

代码以下: mysql> select * from sales;

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');

简单语句
代码以下:
SELECT CASE WHEN 10*2=30 THEN '30 correct'
?? WHEN 10*2=40 THEN '40 correct'
?? ELSE 'Should be 10*2=20'
END AS `result`;
多重表达式
代码以下: SELECT CASE 10*2
?? WHEN 20 THEN '20 correct'
?? WHEN 30 THEN '30 correct'
?? WHEN 40 THEN '40 correct'
?? ELSE 'No results'
END AS `result`;
在SELECT查询中使用CASE WHEN
代码以下: CREATE TABLE DVDs (
?? ID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
?? Name VARCHAR(60) NOT NULL,
?? NumDisks TINYINT NOT NULL DEFAULT 1,
?? RatingID VARCHAR(4) NOT NULL,
?? StatID CHAR(3) NOT NULL
) ENGINE=INNODB;
INSERT INTO DVDs (Name,NumDisks,RatingID,StatID)
VALUES ('Christmas',1,'NR','s1'),('Doc','G',? 's2'),('Africa','PG',('Falcon','s2'),
?????? ('Amadeus',('Show',2,('View',('Mash','R',? 's2');
SELECT Name,RatingID AS Rating,
?? CASE RatingID
????? WHEN 'R' THEN 'Under 17 requires an adult.'
????? WHEN 'X' THEN 'No one 17 and under.'
????? WHEN 'NR' THEN 'Use discretion when renting.'
????? ELSE 'OK to rent to minors.'
?? END AS Policy
FROM DVDs
ORDER BY Name;

MYSQL数据库8 rows in set (0.01 sec)

欢迎参与《Mysql必读MySQL的CASE WHEN语句的几个使用实例》讨论，分享您的想法，编程之家 52php.cn为您提供专业教程。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!