下面建表语句是MySQL，其他看阿里云盘压缩包

  1. CREATE TABLE EMP
  2.        (EMPNO INTEGER NOT NULL,
  3.         ENAME VARCHAR(10),
  4.         JOB VARCHAR(9),
  5.         MGR INTEGER,
  6.         HIREDATE DATE,
  7.         SAL INTEGER,
  8.         COMM INTEGER,
  9.         DEPTNO INTEGER);
  11. INSERT INTO EMP VALUES (7369, 'SMITH',  'CLERK',     7902, '1980-12-17',  800,  NULL, 20);
  12. INSERT INTO EMP VALUES (7499, 'ALLEN',  'SALESMAN',  7698, '1981-2-20',   1600, 300,  30);
  13. INSERT INTO EMP VALUES (7521, 'WARD',   'SALESMAN',  7698, '1981-2-22',   1250, 500,  30);
  14. INSERT INTO EMP VALUES (7566, 'JONES',  'MANAGER',   7839, '1981-4-2',    2975, NULL, 20);
  15. INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN',  7698, '1981-9-28',   1250, 1400, 30);
  16. INSERT INTO EMP VALUES (7698, 'BLAKE',  'MANAGER',   7839, '1981-5-1',    2850, NULL, 30);
  17. INSERT INTO EMP VALUES (7782, 'CLARK',  'MANAGER',   7839, '1981-6-9',    2450, NULL, 10);
  18. INSERT INTO EMP VALUES (7788, 'SCOTT',  'ANALYST',   7566, '1982-12-9',   3000, NULL, 20);
  19. INSERT INTO EMP VALUES (7839, 'KING',   'PRESIDENT', NULL, '1981-11-17',  5000, NULL, 10);
  20. INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN',  7698, '1981-9-8',    1500,    0, 30);
  21. INSERT INTO EMP VALUES (7876, 'ADAMS',  'CLERK',     7788, '1983-1-12',   1100, NULL, 20);
  22. INSERT INTO EMP VALUES (7900, 'JAMES',  'CLERK',     7698, '1981-12-3',   950,  NULL, 30);
  23. INSERT INTO EMP VALUES (7902, 'FORD',   'ANALYST',   7566, '1981-12-3',   3000, NULL, 20);
  24. INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK',     7782, '1982-1-23',   1300, NULL, 10);
  26. CREATE TABLE DEPT
  27.        (DEPTNO INTEGER,
  28.         DNAME VARCHAR(14),
  29.         LOC VARCHAR(13) );
  31. INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
  32. INSERT INTO DEPT VALUES (20, 'RESEARCH',   'DALLAS');
  33. INSERT INTO DEPT VALUES (30, 'SALES',      'CHICAGO');
  34. INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');
  36. CREATE TABLE T1 (ID INTEGER);
  38. INSERT INTO T1 VALUES (1);
  40. CREATE TABLE T10 (ID INTEGER);
  42. INSERT INTO T10 VALUES (1);
  43. INSERT INTO T10 VALUES (2);
  44. INSERT INTO T10 VALUES (3);
  45. INSERT INTO T10 VALUES (4);
  46. INSERT INTO T10 VALUES (5);
  47. INSERT INTO T10 VALUES (6);
  48. INSERT INTO T10 VALUES (7);
  49. INSERT INTO T10 VALUES (8);
  50. INSERT INTO T10 VALUES (9);
  51. INSERT INTO T10 VALUES (10);
  54. CREATE TABLE T100 (ID INTEGER);
  56. INSERT INTO T100 VALUES (1);
  57. INSERT INTO T100 VALUES (2);
  58. INSERT INTO T100 VALUES (3);
  59. INSERT INTO T100 VALUES (4);
  60. INSERT INTO T100 VALUES (5);
  61. INSERT INTO T100 VALUES (6);
  62. INSERT INTO T100 VALUES (7);
  63. INSERT INTO T100 VALUES (8);
  64. INSERT INTO T100 VALUES (9);
  65. INSERT INTO T100 VALUES (10);
  66. INSERT INTO T100 VALUES (11);
  67. INSERT INTO T100 VALUES (12);
  68. INSERT INTO T100 VALUES (13);
  69. INSERT INTO T100 VALUES (14);
  70. INSERT INTO T100 VALUES (15);
  71. INSERT INTO T100 VALUES (16);
  72. INSERT INTO T100 VALUES (17);
  73. INSERT INTO T100 VALUES (18);
  74. INSERT INTO T100 VALUES (19);
  75. INSERT INTO T100 VALUES (20);
  76. INSERT INTO T100 VALUES (21);
  77. INSERT INTO T100 VALUES (22);
  78. INSERT INTO T100 VALUES (23);
  79. INSERT INTO T100 VALUES (24);
  80. INSERT INTO T100 VALUES (25);
  81. INSERT INTO T100 VALUES (26);
  82. INSERT INTO T100 VALUES (27);
  83. INSERT INTO T100 VALUES (28);
  84. INSERT INTO T100 VALUES (29);
  85. INSERT INTO T100 VALUES (30);
  86. INSERT INTO T100 VALUES (31);
  87. INSERT INTO T100 VALUES (32);
  88. INSERT INTO T100 VALUES (33);
  89. INSERT INTO T100 VALUES (34);
  90. INSERT INTO T100 VALUES (35);
  91. INSERT INTO T100 VALUES (36);
  92. INSERT INTO T100 VALUES (37);
  93. INSERT INTO T100 VALUES (38);
  94. INSERT INTO T100 VALUES (39);
  95. INSERT INTO T100 VALUES (40);
  96. INSERT INTO T100 VALUES (41);
  97. INSERT INTO T100 VALUES (42);
  98. INSERT INTO T100 VALUES (43);
  99. INSERT INTO T100 VALUES (44);
  100. INSERT INTO T100 VALUES (45);
  101. INSERT INTO T100 VALUES (46);
  102. INSERT INTO T100 VALUES (47);
  103. INSERT INTO T100 VALUES (48);
  104. INSERT INTO T100 VALUES (49);
  105. INSERT INTO T100 VALUES (50);
  106. INSERT INTO T100 VALUES (51);
  107. INSERT INTO T100 VALUES (52);
  108. INSERT INTO T100 VALUES (53);
  109. INSERT INTO T100 VALUES (54);
  110. INSERT INTO T100 VALUES (55);
  111. INSERT INTO T100 VALUES (56);
  112. INSERT INTO T100 VALUES (57);
  113. INSERT INTO T100 VALUES (58);
  114. INSERT INTO T100 VALUES (59);
  115. INSERT INTO T100 VALUES (60);
  116. INSERT INTO T100 VALUES (61);
  117. INSERT INTO T100 VALUES (62);
  118. INSERT INTO T100 VALUES (63);
  119. INSERT INTO T100 VALUES (64);
  120. INSERT INTO T100 VALUES (65);
  121. INSERT INTO T100 VALUES (66);
  122. INSERT INTO T100 VALUES (67);
  123. INSERT INTO T100 VALUES (68);
  124. INSERT INTO T100 VALUES (69);
  125. INSERT INTO T100 VALUES (70);
  126. INSERT INTO T100 VALUES (71);
  127. INSERT INTO T100 VALUES (72);
  128. INSERT INTO T100 VALUES (73);
  129. INSERT INTO T100 VALUES (74);
  130. INSERT INTO T100 VALUES (75);
  131. INSERT INTO T100 VALUES (76);
  132. INSERT INTO T100 VALUES (77);
  133. INSERT INTO T100 VALUES (78);
  134. INSERT INTO T100 VALUES (79);
  135. INSERT INTO T100 VALUES (80);
  136. INSERT INTO T100 VALUES (81);
  137. INSERT INTO T100 VALUES (82);
  138. INSERT INTO T100 VALUES (83);
  139. INSERT INTO T100 VALUES (84);
  140. INSERT INTO T100 VALUES (85);
  141. INSERT INTO T100 VALUES (86);
  142. INSERT INTO T100 VALUES (87);
  143. INSERT INTO T100 VALUES (88);
  144. INSERT INTO T100 VALUES (89);
  145. INSERT INTO T100 VALUES (90);
  146. INSERT INTO T100 VALUES (91);
  147. INSERT INTO T100 VALUES (92);
  148. INSERT INTO T100 VALUES (93);
  149. INSERT INTO T100 VALUES (94);
  150. INSERT INTO T100 VALUES (95);
  151. INSERT INTO T100 VALUES (96);
  152. INSERT INTO T100 VALUES (97);
  153. INSERT INTO T100 VALUES (98);
  154. INSERT INTO T100 VALUES (99);
  155. INSERT INTO T100 VALUES (100);
  157. CREATE TABLE `emp_bonus` (
  158.   EMPNO INTEGER NOT NULL,
  159.   RECEIVED DATE ,
  160.   TYPE INT
  161. ) ENGINE = INNODB DEFAULT CHARSET = utf8;
  163. INSERT INTO emp_bonus VALUES (7934, '2005-03-17',  1);
  164. INSERT INTO emp_bonus VALUES (7934, '2005-02-15',  2);
  165. INSERT INTO emp_bonus VALUES (7839, '2005-02-15',  3);
  166. INSERT INTO emp_bonus VALUES (7782, '2005-02-15',  1);

Oracle

  1. CREATE TABLE EMP  (
  2.  EMPNO NUMBER , 
  3.  ENAME VARCHAR2(10) , 
  4.  JOB VARCHAR2(10) , 
  5.  MGR NUMBER , 
  6.  HIREDATE DATE , 
  7.  SAL NUMBER , 
  8.  COMM NUMBER , 
  9.  DEPTNO NUMBER 
  10.  );
  13. INSERT INTO EMP VALUES
  14.         (7369, 'SMITH',  'CLERK',     7902,
  15.         to_date('1980-12-17','YYYY-MM-DD' ),  800, NULL, 20);
  16. INSERT INTO EMP VALUES
  17.         (7499, 'ALLEN',  'SALESMAN',  7698,
  18.         to_date('1981-02-20','YYYY-MM-DD' )), 1600,  300, 30);
  19. INSERT INTO EMP VALUES
  20.         (7521, 'WARD',   'SALESMAN',  7698,
  21.         to_date('1981-92-22'), 1250,  500, 30);
  22. INSERT INTO EMP VALUES
  23.         (7566, 'JONES',  'MANAGER',   7839,
  24.         to_date('1981-04-02','YYYY-MM-DD' ),  2975, NULL, 20);
  25. INSERT INTO EMP VALUES
  26.         (7654, 'MARTIN', 'SALESMAN',  7698,
  27.         to_date('1981-09-28','YYYY-MM-DD' ), 1250, 1400, 30);
  28. INSERT INTO EMP VALUES
  29.         (7698, 'BLAKE',  'MANAGER',   7839,
  30.         to_date('1981-05-01','YYYY-MM-DD' ),  2850, NULL, 30);
  31. INSERT INTO EMP VALUES
  32.         (7782, 'CLARK',  'MANAGER',   7839,
  33.         to_date('1981-06-09','YYYY-MM-DD' ),  2450, NULL, 10);
  34. INSERT INTO EMP VALUES
  35.         (7788, 'SCOTT',  'ANALYST',   7566,
  36.         to_date('1982-12-09','YYYY-MM-DD' ), 3000, NULL, 20);
  37. INSERT INTO EMP VALUES
  38.         (7839, 'KING',   'PRESIDENT', NULL,
  39.         to_date('1981-11-17','YYYY-MM-DD' ), 5000, NULL, 10);
  40. INSERT INTO EMP VALUES
  41.         (7844, 'TURNER', 'SALESMAN',  7698,
  42.         to_date('1981-09-08','YYYY-MM-DD' ),  1500,    0, 30);
  43. INSERT INTO EMP VALUES
  44.         (7876, 'ADAMS',  'CLERK',     7788,
  45.         to_date('1983-01-12','YYYY-MM-DD' ), 1100, NULL, 20);
  46. INSERT INTO EMP VALUES
  47.         (7900, 'JAMES',  'CLERK',     7698,
  48.         to_date('1981-12-03','YYYY-MM-DD' ),   950, NULL, 30);
  49. INSERT INTO EMP VALUES
  50.         (7902, 'FORD',   'ANALYST',   7566,
  51.         to_date('1981-12-03','YYYY-MM-DD' ),  3000, NULL, 20);
  52. INSERT INTO EMP VALUES
  53.         (7934, 'MILLER', 'CLERK',     7782,
  54.         to_date('1982-01-23','YYYY-MM-DD' ), 1300, NULL, 10);
  57. CREATE TABLE DEPT
  58.        (DEPTNO NUMBER,
  59.         DNAME VARCHAR2(14),
  60.         LOC VARCHAR2(13) );
  62. INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
  63. INSERT INTO DEPT VALUES (20, 'RESEARCH',   'DALLAS');
  64. INSERT INTO DEPT VALUES (30, 'SALES',      'CHICAGO');
  65. INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');
  68. CREATE TABLE T1 (ID INTEGER);
  70. INSERT INTO T1 VALUES (1);
  72. CREATE TABLE T10 (ID INTEGER);
  74. INSERT INTO T10 VALUES (1);
  75. INSERT INTO T10 VALUES (2);
  76. INSERT INTO T10 VALUES (3);
  77. INSERT INTO T10 VALUES (4);
  78. INSERT INTO T10 VALUES (5);
  79. INSERT INTO T10 VALUES (6);
  80. INSERT INTO T10 VALUES (7);
  81. INSERT INTO T10 VALUES (8);
  82. INSERT INTO T10 VALUES (9);
  83. INSERT INTO T10 VALUES (10);
  86. CREATE TABLE T100 (ID INTEGER);
  88. insert into t100 values (1);
  89. insert into t100 values (2);
  90. insert into t100 values (3);
  91. insert into t100 values (4);
  92. insert into t100 values (5);
  93. insert into t100 values (6);
  94. insert into t100 values (7);
  95. insert into t100 values (8);
  96. insert into t100 values (9);
  97. insert into t100 values (10);
  98. insert into t100 values (11);
  99. insert into t100 values (12);
  100. insert into t100 values (13);
  101. insert into t100 values (14);
  102. insert into t100 values (15);
  103. insert into t100 values (16);
  104. insert into t100 values (17);
  105. insert into t100 values (18);
  106. insert into t100 values (19);
  107. insert into t100 values (20);
  108. insert into t100 values (21);
  109. insert into t100 values (22);
  110. insert into t100 values (23);
  111. insert into t100 values (24);
  112. insert into t100 values (25);
  113. insert into t100 values (26);
  114. insert into t100 values (27);
  115. insert into t100 values (28);
  116. insert into t100 values (29);
  117. insert into t100 values (30);
  118. insert into t100 values (31);
  119. insert into t100 values (32);
  120. insert into t100 values (33);
  121. insert into t100 values (34);
  122. insert into t100 values (35);
  123. insert into t100 values (36);
  124. insert into t100 values (37);
  125. insert into t100 values (38);
  126. insert into t100 values (39);
  127. insert into t100 values (40);
  128. insert into t100 values (41);
  129. insert into t100 values (42);
  130. insert into t100 values (43);
  131. insert into t100 values (44);
  132. insert into t100 values (45);
  133. insert into t100 values (46);
  134. insert into t100 values (47);
  135. insert into t100 values (48);
  136. insert into t100 values (49);
  137. insert into t100 values (50);
  138. insert into t100 values (51);
  139. insert into t100 values (52);
  140. insert into t100 values (53);
  141. insert into t100 values (54);
  142. insert into t100 values (55);
  143. insert into t100 values (56);
  144. insert into t100 values (57);
  145. insert into t100 values (58);
  146. insert into t100 values (59);
  147. insert into t100 values (60);
  148. insert into t100 values (61);
  149. insert into t100 values (62);
  150. insert into t100 values (63);
  151. insert into t100 values (64);
  152. insert into t100 values (65);
  153. insert into t100 values (66);
  154. insert into t100 values (67);
  155. insert into t100 values (68);
  156. insert into t100 values (69);
  157. insert into t100 values (70);
  158. insert into t100 values (71);
  159. insert into t100 values (72);
  160. insert into t100 values (73);
  161. insert into t100 values (74);
  162. insert into t100 values (75);
  163. insert into t100 values (76);
  164. insert into t100 values (77);
  165. insert into t100 values (78);
  166. insert into t100 values (79);
  167. insert into t100 values (80);
  168. insert into t100 values (81);
  169. insert into t100 values (82);
  170. insert into t100 values (83);
  171. insert into t100 values (84);
  172. insert into t100 values (85);
  173. insert into t100 values (86);
  174. insert into t100 values (87);
  175. insert into t100 values (88);
  176. insert into t100 values (89);
  177. insert into t100 values (90);
  178. insert into t100 values (91);
  179. insert into t100 values (92);
  180. insert into t100 values (93);
  181. insert into t100 values (94);
  182. insert into t100 values (95);
  183. insert into t100 values (96);
  184. insert into t100 values (97);
  185. insert into t100 values (98);
  186. insert into t100 values (99);
  187. insert into t100 values (100);