007--MySQL版的Oracle员工表

最新推荐文章于 2023-09-19 12:00:03 发布

enzoism

最新推荐文章于 2023-09-19 12:00:03 发布

阅读量666

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/weixin_42288943/article/details/88401563

1.MYSQL版的Oracle员工表

create table EMP
(
EMPNO numeric(4) PRIMARY KEY,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR numeric(4),
HIREDATE DATE,
SAL numeric(7,2),
COMM numeric(7,2),
DEPNO numeric(4)
);
 
CREATE TABLE Dept(
DEPTNO numeric(4),
DNAME VARCHAR(14),
LOC VARCHAR(13)
);
 
CREATE TABLE Salgrade
(
GRADE numeric,
LOSAL  numeric,
HISAL numeric 
);
 
CREATE TABLE Bonus
(
ENAME VARCHAR(10),
JOB VARCHAR(9),
SAL numeric,
COMM numeric
);
 
INSERT INTO Dept VALUES (10,'ACCOUNTING','NEW YORK');
INSERT INTO Dept VALUES (20,'RESEARCH','DALLAS');
INSERT INTO Dept VALUES (30,'SALES','CHICAGO');
INSERT INTO Dept VALUES (40,'OPERATIONS','BOSTON');
 
INSERT INTO EMP VALUES
(7369,'SMITH','CLERK',7902,'1980-12-17',800,null,20);
INSERT INTO EMP VALUES
(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
INSERT INTO EMP VALUES
(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
INSERT INTO EMP VALUES
(7566,'JONES','MANAGER',7839,'1981-04-02',2975