select database();
use capitalist;
show tables;
drop table if exists staff;
create table staff(
id int primary key,-- 主键自带非空且唯一
name varchar(30) not null unique,-- 不为空且唯一,实际中当然不唯一
join_date date not null,-- 入职日期
salary double(7,2) not null,
bonus double(7,2) default 0);
-- 演示主键约束
insert into staff(id, name, join_date, salary, bonus) values
(null,'董佳宁','2018-09-01',20000.0,8000.0);
select * from staff;
insert into staff(id, name, join_date, salary, bonus) values
('董佳宁','2018-09-01',20000.0,8000.0);
insert into staff(id, name
20220602_Mysql约束Constraint语法_外键
最新推荐文章于 2022-10-31 16:13:34 发布