黑马程序员MySQL知识精讲+mysql实战案例_零基础mysql数据库入门到高

p100

create table emp(

empno INT PRIMARY KEY,

ename VARCHAR(20),

job VARCHAR(20),

mgr INT,

hiredate DATE,

sal NUMERIC(8,2),

comm NUMERIC(8, 2),

deptno INT

);

insert into emp values(1001,'甘宁','文员', 1013,'2000-12-12',8000.00,null,20),

 (1002,'黛绮丝','销售员', 1006,'2001-02-20',16000.00,3000.00,30),

 (1003,'殷天正','销售员', 1006,'2001-02-22',12500.00,5000.00,30),

         (1004,'刘备','经理', 1009,'2001-04-02',29750.00,null,20),

 (1005,'谢逊','销售员', 106,'2001-09-28',12500.00,14000,30),

 (1006,'关羽','经理',1009,'2001-05-01',28500.00,null,30),

 (1007,'张飞','经理',1009,'2001-09-01',24500.00,null,10),

 (1008,'诸葛亮','分析师',1004,'2007-04-19',30000.00,null,20),

 (1009,'增阿牛','董事长',null,'2001-11-17',50000.00,null,10),

 (1010,'韦一笑','销售员',1006,'2001-09-08',15000.00,0.00,30),

 (1011,'周泰','文员',1008,'2007-05-23',11000.00,null,20),

 (1012,'程管','文员',1006,'2001-12-03',9500.00,null,30),

 (1013,'庞统','分析师',1004,'2001-12-03',30000.00,null,20),

         (1014,'黄盖','文员',1007,'2002-01-23',13000.00,null,10);