course1.3

mysql -uroot -p123456;

use class;

creste table chufa(

id int primary key auto_increment,

shijian varchar(20),

shijian datatime);

create trigger trigger_1 after insert on grade each row insert into chufa values(null,"insert",now);

insert into grade values(null,1,2017004,65),(null,2,2017004,62),(null,3,2017004,62),(null,1,2017005,58),(null,2,2017005,52),(null,3,2017005,51);

select gcno,grade,if(ggrade>90,"youxiu","yiban") from grade;

select gcno,grade,case when ggrade>90 then "youxiu",case when ggrade>80 then"good",case when ggrade>70 then "yiban",case then ggrade>60 then "jige";