Excel导入MySQL:
先将excel转化为制表符分隔的文本格式;
load data local infile 'D:\data.txt' into table TABLE_NAME fields terminated by '\t';
-- 制表符分隔。 亦可用',' '|' 等符号分隔列
MySQL导出Excel:
select * into outfile 'D:\data.xls' from TABLE_NAME where 1=1;
select * from TABLE_NAME into outfile 'D:\data.xls';
-- 二者均可
-----------------------------------
【来源】https://blog.51cto.com/baser/1383849