Here's the statement:

```
LOAD DATA INFILE '/var/lib/mysql-files/test.csv'
INTO TABLE test 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' 

```

Here's a line that imports fine:

```
1450327840667357185, 1, "This is my text"

```

If the text field has a comma though, it fails. For example, see this line:

```
1450327840667357185, 1, "This is my text, with a comma in it"

```

Why does it fail?

If I escape the comma (by putting a backslash in front of it) it works fine. This does not make sense though. I have stipulated that the fields may be enclosed by double quotes, so why doesn't it accept all the content therein as a content of the field?

If I have to reprocess all the text to quote comma's, it would be a big task.