2019-01-25作业用到的数据库

create table POST(
post_id int(4) PRIMARY key,
post_name varchar(50) not null,
post_desc varchar(100)
);

insert into post
values (1000,"行政助理","行政辅助人员"),(1001,"行政主管","行政负责人"),
(1002,"业务经理","业务处主管"),(1003,"总经理","公司负责人");

create table EMPLOYEE(
emp_id int(4) PRIMARY key,
post_id int(4) not null,
emp_name varchar(100) ,
emp_sex enum('1','2'),
emp_age int(4),
emp_depart varchar(50),
emp_year int(4)
)

insert into EMPLOYEE(emp_id,post_id,emp_name,emp_sex,emp_age,emp_depart,emp_year)
 VALUES (00001,1000,'李晓明','1',25,'行政部',2),(00002,1000,'杨伟林','1',29,'行政部',5)
insert into EMPLOYEE(emp_id,post_id,emp_name,emp_sex,emp_age,emp_depart,emp_year)
 VALUES (00003,1002,'尤志苗','2',33,'业务部',9),(00004,1003,'牛晓飞','1',40,'集团',10)


drop table profile;
create table profile(
profileSeq  int(5) PRI