SQL建库建表定义表简易命令

create database stu

use stu

create table S
(
sno char(6),
sname char(10),
age int,
sex char(2),
constraint PK_S primary key (sno),
constraint CK_age check(age>=0 and age<=150)
)

create table C
(
cno char(8),
cname char(16),
credit int,
constraint PK_C primary key (cno),
constraint CK_credit check (credit>=0)
)

create table SC ( sno char(6),
cno char (8),
constraint PK_SC primary key (sno,cno), constraint FK_s foreign key (sno) references S(sno),
constraint FK_c foreign key (cno) references C(cno)
)

insert into S values ('001','zhang',19,'男')

insert into S values('002','li',16,'女')

select * from S