>>>> 2013/12/18 11:07 -0500, Anthony Ball >>>>
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
Well, strictly speaking, it is a bug, in your file. If you can keep that from happening
that is best, because in a CSV file the quotemark may appear only first, last, or next to
a separator, unless it quotes another quote-mark.
Otherwise, if it is consistent as in Dhaval Jaiswal s (2), only do as he suggests.