1.建表
create database bigData;
use bigData;
create table dept(
`id` INT unsigned primary key NOT NULL AUTO_INCREMENT,
`deptno` mediumint unsigned not NULL DEFAULT 0,
`dname` varchar(20) not null default "",
`loc` VARCHAR(13) not NULL DEFAULT ""
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
create table emp(
id int unsigned primary key not null auto_increment,
empno int unsigned not null default 0,
ename varchar(20) not null default "",
job varchar(20) not null default "",
mgr int unsigned not null default 0,
hiredate date not null,
sal decimal(7,2) not null,
comm decimal(7,2) not null,
deptno int unsigned not null default 0
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
2.设置参数log_bin_trust_function_creators