我的mysql练习语句

删除表中字段

delete from department where did = 2;

delete from department where did = 2;

添加外键

alter table employee add foreign key (dpmt) references department (did);

create database web_data1;
create table department(
did int primary key auto_increment,
dname varchar(20)
);


create table employee(
eid int primary key auto_increment,
ename varchar(20) not null,
ebirthday date,
esex varchar(10),
dpmt int
);
rename table empolyee to employee;
insert into department values (null,'人事部');
insert into department values (null,'财务部');
insert into department values (null,'事业部');


insert into employee values (null,'张三','1987-01-18','男',1);
insert into employee values (null,'张三','1989-02-28','男',2);
insert into employee values (null,'张三','1990-03-10','男',3);
insert into employee values (null,'张三','1988-04-19','男',1);

insert into employee values (null,'李五','1989-12-15','女',null);

 delete from department where did = 3;