mysql练习初始数据

老实先生

已于 2022-11-28 14:24:50 修改

阅读量459

点赞数

分类专栏： mysql 文章标签：数据库开发

于 2022-04-04 12:22:46 首次发布

本文链接：https://blog.csdn.net/pcbhyy/article/details/123951689

版权

mysql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

/*
MySQL Backup
Source Server Version: 5.5.49
Source Database: test
Date: 2017/9/11 06:52:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
--  Table structure for `dept`
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
  `DEPTNO` int(11) NOT NULL,
  `DNAME` varchar(14) DEFAULT NULL,
  `LOC` varchar(13) DEFAULT NULL,
  PRIMARY KEY (`DEPTNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `emp`
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp` (
  `EMPNO` int(11) NOT NULL,
  `ENAME` varchar(10) DEFAULT NULL,
  `JOB` varchar(9) DEFAULT NULL,
  `MGR` int(11) DEFAULT NULL,
  `HIREDATE` date DEFAULT NULL,
  `SAL` decimal(7,2) DEFAULT NULL,
  `COMM` decimal(7,2) DEFAULT NULL,
  `DEPTNO` int(11) DEFAULT NULL,
  PRIMARY KEY (`EMPNO`),
  KEY `FK_DEPTNO` (`DEPTNO`),
  CONSTRAINT `emp_ibfk_1` FOREIGN KEY (`DEPTNO`) REFERENCES `dept` (`DEPTNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `salgrade`
-- ----------------------------
DROP TABLE IF EXISTS `salgrade`;
CREATE TABLE `salgrade` (
  `GRADE` int(11) DEFAULT NULL,
  `LOSAL` int(11) DEFAULT NULL,
  `HISAL` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records 
-- ----------------------------
INSERT INTO `dept` VALUES ('10','ACCOUNTING','NEW YORK'), ('20','RESEARCH','DALLAS'), ('30','SALES','CHICAGO'), ('40','OPERATIONS','BOSTON');
INSERT INTO `emp` VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20'), ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30'), ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30'), ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20'), ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30'), ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30'), ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10'), ('7788','SCOTT','ANALYST','7566','1987-06-13','3000.00',NULL,'20'), ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10'), ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30'), ('7876','ADAMS','CLERK','7788','1987-06-13','1100.00',NULL,'20'), ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30'), ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20'), ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
INSERT INTO `salgrade` VALUES ('1','700','1200'), ('2','1201','1400'), ('3','1401','2000'), ('4','2001','3000'), ('5','3001','9999');