MySQL只从CSV导入单行 [英] MySQL only imports a single row from CSV

问题描述

开发机是一台Mac。我有一些麻烦从CSV导入多个单行到Mysql。这是我的SQL语句：

Development machine is a Mac. I'm having some trouble importing more than a single line from a CSV into Mysql. Here is my SQL statement:

LOAD DATA LOCAL INFILE 'test.csv' 
INTO TABLE students
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(pita, dob, name, grd, asst, loc);

它运行正常，但只导入一个记录。

It runs fine, but only one record is imported. Any idea where I'm going wrong?

推荐答案

检查行结尾：

head -n2 sql.sql | hexdump -C

但最常见的问题，行终止符不是你期望的，尝试：

but the most common problem, the line terminator isn't what you'd expect, try:

LINES TERMINATED BY '\r'

这篇关于MySQL只从CSV导入单行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！