MySQL查询练习
创建原始数据库
部门表dept(部门序号,部门名,部门位置)
员工表emp(员工编号,名字,职业,直接上级编号,受雇日期,月薪,补贴,部门序号)
create database scott;
use scott;
CREATE TABLE DEPT
(DEPTNO INT,
DNAME VARCHAR(20),
LOC VARCHAR(20),
CONSTRAINT PK_DEPT PRIMARY KEY(DEPTNO));
CREATE TABLE EMP
(EMPNO int,
ENAME VARCHAR(20),
JOB VARCHAR(20),
MGR int,
HIREDATE DATE,
SAL int,
COMM int,
DEPTNO int,
CONSTRAINT PK_EMP PRIMARY KEY(EMPNO),
CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO)
REFERENCES DEPT (DEPTNO));
Insert into DEPT (DEPTNO,DNAME,LOC) values (10,'ACCOUNTING','NEW YORK');
Insert into DEPT (DEPTNO,DNAME,LOC) values (20,'RESEARCH','DALLAS');
Insert into DEPT (DEPTNO,DNAME,LOC) values (30,'SALES','CHICAGO');
Insert into