创建数据库:
create database test;
进入数据库:
use test;
创建数据表dept、emp:
create table dept(
deptno int primary key,
dname varchar(15),
loc varchar(10)
);
create table emp(
empno int primary key auto_increment,
ename varchar(15) unique,
job varchar (10) not null default '-',
mgr int,
hiredate date,
sal float default 0,
comm float,
deptno int,
foreign key (deptno) references dept(deptno)
);
导入数据表dept数据:
insert into dept(deptno,dname,loc) values (10,'accounting','new york'),(20,'research','dallas');
insert into dept values (30,'sales','chicago'),(40,'operations','boston');
批量导入数据文件:
-- 首先获取安全路径
show variables like '%secure%';
-- 再操作如下:
load data infile "C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/employee.csv"
into table emp
fields terminated by ','
ignore 1 lines;
查看数据表导入的数据:
select * from emp ;