《数据库概论》实验(2)：交互式SQL--创建表

一、 创建数据库

create database test;
use test;

二、创建表
create table Students
(Sno char(7) primary key,
 Sname varchar(10),
 Ssex char(2) default '男',
 Sbirthday date,
 Sdept varchar(12),
 Memo varchar(30)
);

create table Courses
(Cno varchar(4) primary key,
 Cname varchar(20),
 PreCno varchar(4),
 Credit tinyint
);

create table SC
(Sno char(7),
 Cno varchar(4),
 Grade tinyint,
 foreign key(sno) references Students(Sno),
 foreign key(cno) references Courses(Cno),
 primary key(Sno,Cno)
);

三、向表中插入数据

insert into students values('0602001','钟耀华','男','1987-05-01','计算机','优秀毕业生');
insert into students values('0602002','吴佳硕','女','1987-03-24','计算机','爱好:音乐');
insert into students values('