* 表stu01 ``` drop table if exists stu01; create table stu01( sno int(8) primary key, ##学员编号 sname varchar(20), ##学员姓名 sex char(3), ##性别 age int(3), ##学员年龄 etime date, ##入学时间 address varchar(50) ##地址 ); insert into stu01(sno,sname,sex,age,etime,address) values(2019001,'Tom','男',20,'2019-10-12','北京'), (2019002,'Rose','男',22,'2014-10-2','上海'), (2019003,'Jack','男',25,'2016-10-3','广州'), (2019004,'Smith','男',30,'2018-10-5','深圳'), (2019005,'Jones','女','18','2018-10-12','成都'), insert into stu01(sno,sname,sex,age,etime) values(2019006,'Jims','男',20,'2014-10-9'); insert into stu01(sno,sname,sex,etime,address) values(2019007,'Polla','女','2015-10-8','重庆'); insert into stu01(sno,sname,age,etime) values(2019008,'Tyta',28,'2016-10-5'); insert into stu01(sno,sname,sex,age,etime,address) values(2019009,'Koal','男',40,'2018-10-6','石家庄'), (2019010,'Hoyu','女',23,'2017-10-3','西安'), (2019011,'Finel','女',34,'2018-10-10','长沙'); insert into stu01(sno,sname,age,address) values(2019012,'Bill',23,'杭州'); ``` * 表cou01 ``` drop table if exists cou01; create table cou01( cno int(4) primary key,##课程编号 cname varchar(30) ##课程姓名 ); insert into cou01(cno,cname) values (1001,'数据库技术'), (1002,'软件测试'), (1003,'软件研发'), (1004,'影视编辑'), (1005,'市场营销'); ``` * 表sco01 ``` drop table if exists sco01; create table sco01( sno int(8), ##学员编号 cno int(8), ##课程编号 grade double(4,1) ##学员成绩 ); insert into sco01(sno,cno,garde) values (2019001,1001,80), (2019002,1001,60), (2019002,1002,90), (2019003,1003,66.5), (2019004,1005,78), (2019001,1003,55.5), (2019004,1003,66), (2019006,1002,120), (2019005,1002,78), (2019007,1005,85), (2019002,1003,92), (2019003,1004,70.5), (2019006,1003,75), (2019008,1004,72), (2019005,1001,56); ``` ``` select * from stu01; select * from cou01; select * from sco01; ```