create database emp37;
2 use emp37;
Ocreate table emp37(
id int auto_increment primary key,
5 name varchar(20) not null,
age int check( age>8 and age<150),
job varchar(20), Eile
salary varchar(10000), Dat
entrydate date,
10 managerid int,
dept_id int
12 );
1314 insert into emp37 (name, age, job, salary,entrydate,managerid,dept_id) values ('金庸',66,‘总裁”,20000,'2000-01-01',null,5), fo
15 ('张无忌’,20,'项目经理”,12500,'2005-12-05',1,1),
('杨逍’,33,‘开发’,8400,'2000-11-03',2,1), k
16
17 ('韦一笑',48,'开发’,11000,'2002-02-05',2,1),
18 ('常過春’,43,'开发’,10500,'2004-09-07',3,1),
19 ('小昭’,19,程序员鼓励师’,6600,2004-10-12',2,1),
20 ('灭绝’,60,'财务总监’,8500,'2002-09-12',1,3),
('周芷若’,19,‘会计',48000,‘2006-06-02',7,3),
21
22 ('丁敏君’,23,'出纳”,5250,'2009-05-13',7,3),
23 ('赵敏’,20,,市场部总监’,12500,'2004-10-12',1,2),
24 ('鹿杖客',56,‘职员',3750,'2006-10-03',10,2),
25 ('鹤笔翁’,19,‘职员’,3750,'2007-05-09', 10,2), S
('方东白’,19,‘职员”,5500,'2009-02-12',10,2), T
('张三丰’,88,'销售总监',14000,'2004-10-12',1,4),('俞莲舟*,38,'销售”,4600,'2004-10-12',14,4),
28
('宋远桥’,40,‘销售',4600,'2004-10-12',14,4),('陈友谅’,42,nut1,2000,'2011-10-12 ,1,nutt