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;