* 表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; ```