mysql> create table user_2(id int primary key auto_increment,name varchar(10) not null unique ,age tinyint check(age > 0 && age <=120),status char(1) default 1,gender char(1));
Query OK, 0 rows affected, 1 warning (0.01 sec)
外键约束
添加外键
alter table emp3 add constraint fk_emp3_dept_id foreign key (dept_id) references dept(id);
删除外键
[23000][1451] Cannot delete or update a parent row: a foreign key constraint fails (`itcast`.`emp3`, CONSTRAINT `fk_emp3_dept_id` FOREIGN KEY (`dept_id`) REFERENCES `dept` (`id`))