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

posted @ 2018-12-07 13:57 MAU 阅读(...) 评论(...) 编辑 收藏
Life will always knock us down, but we can choose whether to stand back up, then keep fighting. 生活会把我们打趴下,但我们可以选择重新站起来,继续奋斗。