嗯 我试图重复这个问题，但是不能。我的数据与您的数据有何不同？您可以提供样本数据来重复吗？这是我所做的：
> cat /tmp/data.csv"aaaa","bbb ""ccc"" ddd",xxxxxx,yyy,"zzz ""ooo"""foo,bar,bazmysql> CREATE TABLE t2 (a varchar(20), b varchar(20), c varchar(20));Query OK, 0 rows affected (0.01 sec)mysql> LOAD DATA INFILE '/tmp/data.csv' INTO TABLE t2 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' (a, b, c);Query OK, 3 rows affected (0.00 sec)Records: 3 Deleted: 0 Skipped: 0 Warnings: 0mysql> select * from t2;+------+---------------+-----------+| a | b | c |+------+---------------+-----------+| aaaa | bbb "ccc" ddd | xxx || xxx | yyy| zzz "ooo" || foo | bar| baz |+------+---------------+-----------+3 rows in set (0.00 sec)
对我看来还行（？）
另请注意，如果您在Windows平台上工作，则可能需要使用它
LINES TERMINATED BY 'rn'。
