mysql 导入 CSV文件命令行 ERROR 13 (HY000): Can't get stat of

一定要查看好CSV字段结构是否和文件的表结构字段一致

　　load data local infile 'F:/MySqlData/test1.csv' --CSV文件存放路径
　　into table student--要将数据导入的表名
　　fields terminated by ',' optionally enclosed by '"' escaped by '"'
　　lines terminated by '\r\n';

MariaDB [meng]> load data local infile "/home/cyc/main_auth_user.csv"
    -> into table auth_user
    -> fields terminated by ',' optionally enclosed by '"' escaped by '"'
    -> lines terminated by '\r\n';
Query OK, 65 rows affected, 154 warnings (0.00 sec)

参考链接1
参考链接2

转载于:https://www.cnblogs.com/polly-ling/p/10082539.html