I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.

I have a csv file with space between the " and , and it causes MySQL to eat
that field and the field after it as a single field. Is there a setting I
can use to remedy this or do I just have to make sure no whitespace
intrudes?

Here is an example:

"testa" ,"testb"



create temporary table testa (a char(15), b char(5)); LOAD DATA LOCAL
INFILE '/tmp/test.csv' INTO TABLE testa FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"';



Data in table is

mysql> select * from testa;
+----------------+------+
| a | b |
+----------------+------+
| testa" ,"testb | NULL |
+----------------+------+