(1)
yes it is an issue even i faced. for the remedy i search the {(" ,) (",)}
values of " , space between " and , & replaced by ", in .csv itself.
(2)
The other way is, if all the values are like space between " , then you can
use space and , in fields terminated by
LOAD DATA LOCAL INFILE '/tmp
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 n
