使用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');
8 rows in set (0.01 sec)
如对本文有疑问, 点击进行留言回复!!
在Ubuntu/Linux环境下使用MySQL开放/修改3306端口和开放访问权限
ORM框架Peewee(高级连接)peewee连接池、主从、重连、ssh连接
记一次Mysql主从复制延迟,Waiting for dependent transaction to commit
网友评论