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='';

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

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