INSERT INTO dept_test VALUES(10,'developer','beijing');
INSERT INTO dept_test VALUES(20,'account','shanghai');
INSERT INTO dept_test VALUES(30,'sales','guangzhou');
INSERT INTO dept_test VALUES(40,'operations','tianjin');
INSERT INTO emp_test VALUES(1001,'张无忌','Manager','10000','2000',DATE_FORMAT('2010-01-12','%y-%m-%d'),1005,10);
INSERT INTO emp_test VALUES(1002,'刘苍松','Analyst',8000,1000,DATE_FORMAT('2011-01-12','%y-%m-%d'),1001,10);
INSERT INTO emp_test VALUES(1003,'李翊','Analyst',9000,1000,DATE_FORMAT('2010-02-11','%y-%m-%d'),1001,10);
INSERT INTO emp_test VALUES(1004,'郭芙蓉','Programmer',5000, NULL ,DATE_FORMAT('2010-02-11','%y-%m-%d'),1001,10);
INSERT INTO emp_test VALUES(1005,'张三丰','President',15000, NULL ,DATE_FORMAT('2008-02-15','%y-%m-%d'),NULL,20);
INSERT INTO emp_test VALUES(1006,'燕小六','Manager',5000,400,DATE_FORMAT('2009-02-12','%y-%m-%d'),1005,20);
insert into emp_test values(1007,'陆无双','clerk',3000,500,DATE_FORMAT('2009-02-01','%y-%m-%d'),1006,20);
insert into emp_test values(1008,'黄蓉','Manager',5000,500,DATE_FORMAT('2009-11-01','%y-%m-%d'),1005,30);
insert into emp_test values(1009,'韦小宝','salesman',4000, null ,DATE_FORMAT('2009-05-20','%y-%m-%d'),1008,30);
insert into emp_test values(1010,'郭靖','salesman',4500,500,DATE_FORMAT('2009-10-10','%y-%m-%d'),1008,30);
查看员工表数据
SELECT * FROM emp_test;
查看部门表数据
SELECT * FROM dept_test;
查看员工姓名、月薪、年薪
SELECT name,salary,salary*12 year_salary
FROM emp_test;