数据库萌新建表

xixihahaguan

于 2020-12-17 14:41:27 发布

阅读量79

点赞数

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/xixihahaguan/article/details/111314867

版权

数据库建表

// A code block
var foo = 'bar';

CREATE TABLE Student(
Sno char(7) PRIMARY KEY,
Sname char(10) NOT NULL,
Ssex char(2),
Sage tinyint,
Sdept varchar(20)
)
CREATE TABLE Course(
Cno char(6) NOT NULL,
Cname varchar(20) NOT NULL,
Grade tinyint,
Semster tinyint,
PRIMARY KEY(Cno)
)
CREATE TABLE SC(
Sno char(7) NOT NULL,
Cno char(6) NOT NULL,
Grade tinyint,
PRIMARY KEY(Sno,Cno),
FOREIGN KEY(Sno) references Student(Sno),
FOREIGN KEY(Cno) references Course(Cno)
)