I am importing text files (csv) using infile in a MySQL database. In the files, there is one field that contains commas itself. Even though I skip it, it gets split in multiple fields and I get erroneous values in the fields that follow. How can I import those files correctly ?
I have tried / optionally enclosed by '"' / but it didn't make any difference.
Thanks in advance for your help !