create table user(
id int primary key auto_increment comment '主键', -- auto_increment(主动自增) primary key(主键)约束
name varchar(10) not null unique comment '姓名', -- not null(不为空) unique(唯一)约束
age int check (age>0&&user.age<=120 )comment '年龄', -- check (age>0&&user.age<=120 )(检查) 约束
status char(1) default '1'comment '状态' , -- default '1'(默认)约束
gender char(1) comment '性别'
)comment '用户表';
-- 插入数据
insert into user(name, age, status, gender) values ('Tom',111,'1','男'), ('KRm',101,'0','男');
insert into user(name, age, status, gender) values ('Pou',67,'0','男');
insert into user(name, age, status, gender) values (null,67,'0','男'); - 报错name字段不能为空
insert into user(name, age, status, gender) values ('Pou',67,'0','男'); - 报错 无法重复执行,因为name是 唯一字段约束,但主键是申请成功的,所以主键会有变化
insert into user(name, age, gender) values('Kpp',67,'男'); - 没传status字段及内容,就会被default '1'(默认)约束 默认status为"1"