Hi I didn't see any difference between using optionally or not.
Any solutions to make the two that fails work? (see test case below) Using 3.23.41. Thanks test.csv: "Record 1","some data","Works" "Record 2",""some" data","Works" "Record 3","some 'data'","Works" "Record 4",""some" "data","Works" "Record 5",""some"data"","Fails" "Record 6","some"data","Works" "Record 7","some data"","Fails" "Record 8","'som"e"'data","Works" "Record 9","some"data","Works" CREATE TABLE quotetest ( name text, content text, description text ); mysql> LOAD DATA INFILE '/home/sql/test.csv' INTO TABLE quotetest FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'; Query OK, 9 rows affected (0.00 sec) Records: 9 Deleted: 0 Skipped: 0 Warnings: 2 mysql> select * from quotetest; +----------+--------------------+-------------+ | name | content | description | +----------+--------------------+-------------+ | Record 1 | some data | Works | | Record 2 | "some" data | Works | | Record 3 | some 'data' | Works | | Record 4 | "some" "data | Works | | Record 5 | "some"data","Fails | NULL | | Record 6 | some"data | Works | | Record 7 | some data","Fails | NULL | | Record 8 | 'som"e"'data | Works | | Record 9 | some"data | Works | +----------+--------------------+-------------+ 9 rows in set (0.00 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
