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

最新推荐文章于 2023-10-12 11:18:13 发布

htl258_Tony

最新推荐文章于 2023-10-12 11:18:13 发布

阅读量1.2k

点赞数

分类专栏：基础应用文章标签： sql insert table database c

基础应用专栏收录该内容

42 篇文章 0 订阅

订阅专栏

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