MYSQL 寒假自学 2022 十（一）

create database mydb3;
use mydb3;
create table if not exists dept
(
	detpno varchar(20) primary key,
	name varchar(20)
);

create table if not exists emp
(
	eid varchar(20) primary key,
	ename varchar(20),
	age int,
	dept_id varchar(20),
	constraint emp_fk foreign key (dept_id) references dept(detpno)

);

create table if not exists dept2
(
	detpno varchar(20) primary key,
	name varchar(20)
);


create table if not exists emp2
(
	eid varchar(20) primary key,
	ename varchar(20),
	age int,
	dept_id varchar(20)

);
alter table emp2 add constraint emp2_fk foreign key (dept_id) references dept2(detpno);

创建外键约束的两种方法