定义主键约束
prinmary key :不允许为空,不允许重复
删除主键:alter table table_name drop primary key;
定义主键自动增长
auto_increment
定义唯一约束
unique
定义非空约束
not null
定义外键约束
constraint ordersid_FK foreign key(ordersid) references orders(id)
主外键举例:
create table husband
(
id int primary key,
name varchar(20),
);
create table wife
(
id int primary key,
name varchar(20),
husband_id int,
constraint husband_id_FK foreign key(husband_id) references husband(id)
);
一对多的关联关系
多对多的关联
一对一的关联