?create table student(
??? sno varchar(20) not null comment'學號',
??? sname varchar(20) not null comment'學生姓名',
??? ssex varchar(20) not null comment'學生性別',
??? sbirthday datetime comment'學生出生年月',
??? class varchar(20) comment '學生所在班級',
??? primary key(sno)
? );
??? ?
? create table course(
???? cno varchar(20) comment'課程號',
????? cname varchar(20) comment'課程名稱',
????? tno varchar(20) comment'教工編號',
????? primary key(cno)
set names gbk;
insert into student values
('108','曾華','男','1997-09-01','95033'),
('105','匡明','男','1975-10-02','95031'),
('107','王麗','女','1976-01-23','95033'),
('101','李軍','女','1976-02-20','95033'),
('109','王芳','女','1976-02-10','95031'),
('103','陸君','男','1974-06-03','95031');
insert into course values
?('3-105','計算機導論','825'),
?('3-245','操作系統','804'),
?('6-166','數字電路','856'),
?('9-888','高等數學','831');
轉載于:https://www.cnblogs.com/hjc1234/p/9459936.html