MySQL练习数据

最新推荐文章于 2024-07-06 16:43:12 发布

shphuang

最新推荐文章于 2024-07-06 16:43:12 发布

阅读量698

点赞数 2

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.csdn.net/qq_43567345/article/details/105661243

版权

MySQL 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

这是MySQL的测试数据：
包含三张表：emp，dept，salgrade

create table dept
(
deptno	int(11)	not null primary key,
loc	varchar(300),
dname	varchar(100)
)DEFAULT CHARSET=gb2312;

CREATE TABLE emp
(
empno INT NOT NULL PRIMARY KEY,
ename VARCHAR(30),
job VARCHAR(30),
mgr INT,
datet DATETIME,
sal FLOAT,
comm FLOAT,
deptno INT
)DEFAULT CHARSET=gb2312;

CREATE TABLE salgrade
(
GRADE INT NOT NULL PRIMARY KEY,
LOSAL FLOAT,
HISAL FLOAT
)DEFAULT CHARSET=gb2312;

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',1456.00,800.00,20);
INSERT INTO emp VALUES(7499,'ALLEN','SALESMAN'/*推销员*/,7698,'1981-2-20',1600.00,300.00,30);
INSERT INTO emp VALUES(7521,'WARD','SALESMAN',7698,'1981-2-22',1250.00,500.00,30);
INSERT INTO emp VALUES(7566,'JONES','MANAGER'/*经理*/,7839,'1981-4-2',2975.00,2300.00,20);
INSERT INTO emp VALUES(7654,'MARTIN','SALESMAN',7698,'1981-9-28',1250.00,1400.00,30);
INSERT INTO emp VALUES(7698,'BLAKE','MANAGER',7839,'1981-5-1',2850.00,1020.00,30);
INSERT INTO emp VALUES(7782,'CLARK','MANAGER',7839,'1981-6-9',2450.00,200.00,10);
INSERT INTO emp VALUES(7788,'SCOTT','ANALYST',7566,'1987--4-19',3000.00,2000.00,20);
INSERT INTO emp VALUES(7839,'KING','PRESIDENT'/*总裁*/,7765,'1981-11-17',5000.00,1500.00,10);
INSERT INTO emp VALUES(7844,'TURNER','SALESMAN',7698,'1981-9-8',1500.00,0.00,30);
INSERT INTO emp VALUES(7876,'ADAMS','CLERK',7788,'1987-5-23',11000.00,2500,20);
INSERT INTO emp VALUES(7900,'JAMES','CLERK',7698,'1981-12-3',9500.00,600.00,30);
INSERT INTO emp VALUES(7902,'FORD','ANALYST',7566,'1981-12-3',3000.00,500.00,20);
INSERT INTO emp VALUES(7934,'MILLER','CLERK',7782,'1982-1-23',1300.00,400.00,10);
INSERT INTO emp VALUES(9999,'SHUNPING','CLERK',7782,'1988-5-5',2456.34,55.66,10);


INSERT INTO salgrade VALUES(1,700,1200);
INSERT INTO salgrade VALUES(2,1201,1400);
INSERT INTO salgrade VALUES(3,1401,2000);
INSERT INTO salgrade VALUES(4,2001,3000);
INSERT INTO salgrade VALUES(5,3001,9999);