csv导入mysql 大数据量_csv 导入、导出到mysql的数据量达到百万以上

整理要导入的excel数据(***  必须要有表头)

1、把要导入的excel文件另存为utf8 的CSV文件

2、把CSV文件放到/var/lib/mysql-files

mysql

1、进入mysql

mysql -u用户名  -p  回车 输入密码

2、切换到要导入的数据库

use  数据库名;

3、创建表，表结构要跟excel的表头相同

4、导入

load data infile "/var/lib/mysql-files/****.csv" into table  表名    fields terminated by ',';

5、导出

SELECT * FROM 表名   INTO OUTFILE '/var/lib/mysql-files/mytable1.csv' character set gbk  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

报以下错误的话：执行   set sql_mode='';

ERROR 1261 (01000): Row 1 does not contain data for all columns

ERROR 1262 (01000): Row 1 was truncated; it contained more data than there were input columns