);
> OK
> 时间: 0.006s
CREATE TABLE teacher(
tid int(10) PRIMARY KEY AUTO_INCREMENT,
tname varchar(50) NOT NULL
);
> OK
> 时间: 0.006s
CREATE TABLE course(
cid int(10) PRIMARY KEY AUTO_INCREMENT,
cname varchar(50) NOT NULL,
t_id int(10) NOT NULL,
FOREIGN KEY (t_id) REFERENCES teacher (tid)
) ;
> OK
> 时间: 0.011s
CREATE TABLE student(
sid int(10) PRIMARY KEY AUTO_INCREMENT,
sname varchar(50) NOT NULL,
gender char(1) NOT NULL,
c_id int(10) NOT NULL,
FOREIGN KEY (c_id) REFERENCES class (cid)
) ;
> OK
> 时间: 0.009s
CREATE TABLE score (
sid int(10) PRIMARY KEY AUTO_INCREMENT,
c_id int(10) NOT NULL,
s_id int(10) NOT NULL,
snum int(10) NOT NULL,
FOREIGN KEY (c_id) REFERENCES course (cid),
FOREIGN KEY (s_id) REFERENCES student(sid)
) ;
> OK
> 时间: 0.012s
通过以上的语句,就分别把表创建好了。