2.数值函数
日期函数
流程函数
select if(true,'ok','error');
ok
select ifnull(null,'default');
default
创建一个学生成绩表
create table score(
id int comment'学号',
name varchar(10) comment'姓名',
English int comment'英语',
math int comment'数学',
Chinese int comment'语文'
) comment '成绩表';
加入数据
insert into score(id, name, English, math, Chinese) value (1,'jack',56,89,69);
insert into score(id, name, English, math, Chinese) value (2,'marry',54,36,88);
insert into score(id, name, English, math, Chinese) value (3,'hook',60,98,96);
显示成绩以优秀及格不及格来显示
select
id,
name,
(case when English >85 then '优秀' when English>=60 then '及格'when English<60 then '不及格' end )as 'English',
(case when math >85 then '优秀' when math>=60 then '及格'when math<60 then '不及格' end )as 'math',
(case when Chinese >85 then '优秀' when Chinese>=60 then '及格'when Chinese<60 then '不及格' end) 'Chinese'
from score;