mysql版-emp和dept表结构和数据

1. SET NAMES utf8mb4;
2. SET FOREIGN_KEY_CHECKS = 0;
4. -- ----------------------------
5. -- Table structure for dept
6. -- ----------------------------
7. DROP TABLE IF EXISTS `dept`;
8. CREATE TABLE `dept`  (
9.   `deptno` int(0) NOT NULL COMMENT '部门编号',
10.   `dname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
11.   `loc` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
12.   `memo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注说明',
13.   PRIMARY KEY (`deptno`) USING BTREE
14. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
16. -- ----------------------------
17. -- Records of dept
18. -- ----------------------------
19. INSERT INTO `dept` VALUES (10, 'ACCOUNTING', 'NEW YORK', '会计部');
20. INSERT INTO `dept` VALUES (20, 'RESEARCH', 'DALLAS', '研究部');
21. INSERT INTO `dept` VALUES (30, 'SALES', 'CHICAGO', '销售部');
22. INSERT INTO `dept` VALUES (40, 'OPERATIONS', 'BOSTON', '业务部');
24. -- ----------------------------
25. -- Table structure for emp
26. -- ----------------------------
27. DROP TABLE IF EXISTS `emp`;
28. CREATE TABLE `emp`  (
29.   `empno` int(0) NOT NULL COMMENT '员工编号',
30.   `cname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工中文姓名',
31.   `ename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工英文姓名',
32.   `job` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作岗位',
33.   `mgr` int(0) NULL DEFAULT NULL COMMENT '上级领导',
34.   `hiredate` date NULL DEFAULT NULL COMMENT '入职日期',
35.   `sal` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪水',
36.   `comm` decimal(10, 2) NULL DEFAULT NULL COMMENT '津贴',
37.   `deptno` int(0) NULL DEFAULT NULL COMMENT '部门编号-外键',
38.   `memo` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注说明',
39.   PRIMARY KEY (`empno`) USING BTREE
40. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
42. -- ----------------------------
43. -- Records of emp
44. -- ----------------------------
45. INSERT INTO `emp` VALUES (7369, '黄风', 'SMITH', 'CLERK', 7902, '1980-12-17', 2800.00, NULL, 20, '办事员');
46. INSERT INTO `emp` VALUES (7499, '卢帆新', 'ALLEN', 'SALESMAN', 7698, '1981-02-20', 1600.00, 300.00, 30, '销售员');
47. INSERT INTO `emp` VALUES (7521, '语琴', 'WARD', 'SALESMAN', 7698, '1981-02-22', 1250.00, 500.00, 30, NULL);
48. INSERT INTO `emp` VALUES (7566, '郭俊', 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, NULL, 20, '经理');
49. INSERT INTO `emp` VALUES (7654, '曼文', 'MARTIN', 'SALESMAN', 7698, '1981-09-28', 1250.00, 1400.00, 30, NULL);
50. INSERT INTO `emp` VALUES (7698, '赵羽', 'BLAKE', 'MANAGER', 7839, '1981-05-01', 2850.00, 800.00, 30, NULL);
51. INSERT INTO `emp` VALUES (7782, '李四', 'CLARK', 'MANAGER', 7839, '1981-06-09', 2450.00, NULL, 10, NULL);
52. INSERT INTO `emp` VALUES (7788, '古驰', 'SCOTT', 'ANALYST', 7566, '1987-03-13', 3000.00, 1000.00, 20, '分析师');
53. INSERT INTO `emp` VALUES (7839, '李邦', 'KING', 'PRESIDENT', 7839, '1981-11-17', 5000.00, 1000.00, 10, '主席');
54. INSERT INTO `emp` VALUES (7844, '尤辉', 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500.00, 0.00, 30, NULL);
55. INSERT INTO `emp` VALUES (7876, '妙彤', 'ADAMS', 'CLERK', 7788, '1987-03-13', 1100.00, NULL, 20, NULL);
56. INSERT INTO `emp` VALUES (7900, '张三', 'JAMES', 'CLERK', 7698, '1981-12-03', 950.00, NULL, 30, NULL);
57. INSERT INTO `emp` VALUES (7902, '张三丰', 'FORD', 'ANALYST', 7566, '1981-12-03', 3000.00, 500.00, 20, NULL);
58. INSERT INTO `emp` VALUES (7934, '李四娘', 'MILLER', 'CLERK', 7782, '1982-01-23', 1300.00, NULL, 10, NULL);
60. SET FOREIGN_KEY_CHECKS = 1;

复制代码

 
搜索
复制

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！