mysql 数据库导出
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;
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;