mysql の load data local infile でcsvファイルを読み込ませる時の注意 ref: http://qiita.com/tpyamamoto/items/0214decd4a50c843a23d

file0.sql

load data local infile 'text.csv' INTO table load_test FIELDS terminated by ',' enclosed by '"' escaped by '"';

file1.txt

mysql > desc load_test;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| text1 | varchar(256) | YES  |     | NULL    |       |
| text2 | varchar(256) | YES  |     | NULL    |       |
| text3 | varchar(256) | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+

file2.txt

hunk_1.csv
aaaaaa,bbb""bbbb,cccccccc
xxxxxx,yyy"yyyy",dddddddd

file3.txt

mysql> load data local infile 'hunk_1.csv' INTO table load_test FIELDS terminated by ',' enclosed by '"' escaped by '"';
Query OK, 2 rows affected (0.05 sec)
mysql> select * from load_test;
+-----------+--------------+--------+
| text1     | text2        | text3  |
+-----------+--------------+--------+
| aaaaaaaaa | bbb"bbbb     | cccccc |
| xxxxxx    | yyyyy"yyyyy" | zzzzzz |
+-----------+--------------+--------+

file4.txt

hunk_2.csv
aaaaaa,"bbbbbbb,cccccccc
xxxxxx,yyyy"yyy,dddddddd

file5.txt

mysql> load data local infile 'hunk_2.csv' INTO table load_test FIELDS terminated by ',' enclosed by '"' escaped by '"';
Query OK, 1 row affected, 1 warning (0.05 sec)

mysql> select * from load_test;
+----------------------------+---------------------------------------------+--------+
| text1                      | text2                                       | text3  |
+----------------------------+---------------------------------------------+--------+
| aaaaaa                     | "bbbbbbb,cccccccc
xxxxxx,yyy"yyyy,dddddddd
 | NULL   |
+----------------------------+---------------------------------------------+--------+