立即学习:https://edu.csdn.net/course/play/27328/362525?utm_source=blogtoedu
没有找到PPT课件,pdf课件里没有代码,纯手打,拿去不谢
create table emplyee(
id int not null auto_increment primary key,
name varchar(30) comment '姓名',
sex varchar(1) comment '性别',
salary int comment '工资(元)'
);
insert into emplyee(name, sex, salary) values('张三', '男', 5500);
insert into emplyee(name, sex, salary) values('李洁', '女', 4500);
insert into emplyee(name, sex, salary) values('李小梅', '女', 4200);
insert into emplyee(name, sex, salary) values('欧阳辉', '男', 7500);
insert into emplyee(name, sex, salary) values('李芳', '女', 8500);
insert into emplyee(name, sex, salary) values('张江', '男', 6800);
insert into emplyee(name, sex, salary) values('李四', '男', 12000);
insert into emplyee(name, sex, salary) values('王五', '男', 3500);
insert into emplyee(name, sex, salary) values('马小龙', '男', 6000);
insert into emplyee(name, sex, salary) values('龙五', '男', 8000);
insert into emplyee(name, sex, salary) values('冯小芳', '女', 10000);
insert into emplyee(name, sex, salary) values('马小花', '女', 4000);