首页 / Mysql / MySQL的CASE WHEN语句的几个使用实例

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

使用CASE WHEN进行字符串替换处理
9 rows in set (0.01 sec)SELECT name AS Name,
    CASE category
    WHEN “Holiday” THEN “Seasonal”
    WHEN “Profession” THEN “Bi_annual”
    WHEN “Literary” THEN “Random” END AS “Pattern”
FROM sales;                   

使用CASE WHEN进行字符串替换处理

9 rows in set (0.01 sec)

SELECT name AS Name,
    CASE category
    WHEN “Holiday” THEN “Seasonal”
    WHEN “Profession” THEN “Bi_annual”
    WHEN “Literary” THEN “Random” END AS “Pattern”
FROM sales;                   

9 rows in set (0.00 sec)

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)
) ENGINE=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’);

本文来自网络,不代表我是攻城狮立场,转载请注明出处:https://www.54gcs.cn/sql/mysql/1781.html

helwo作者

上一篇
下一篇

为您推荐

发表评论

联系我们

联系我们

在线咨询: QQ交谈

邮箱: web@5vo.cn

工作时间:周一至周五,9:00-17:30,节假日休息
关注微信
微信扫一扫关注我们

微信扫一扫关注我们

手机访问
手机扫一扫打开网站

手机扫一扫打开网站

返回顶部
跳至工具栏