dept 和emp 表数据、结构

mysql 数据库导出

dept

DROP TABLE IF EXISTS dept;
CREATE TABLE dept (
DEPTNO int(2) NOT NULL,
DNAME varchar(14) COLLATE utf8_bin DEFAULT NULL,
LOC varchar(13) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (DEPTNO)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

---

– Records of dept

---

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’);
SET FOREIGN_KEY_CHECKS=1;

emp

DROP TABLE IF EXISTS dept;
CREATE TABLE dept (
DEPTNO int(2) NOT NULL,
DNAME varchar(14) COLLATE utf8_bin DEFAULT NULL,
LOC varchar(13) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (DEPTNO)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

---

– Records of dept

---

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’);
SET FOREIGN_KEY_CHECKS=1;