title: MySql LOAD DATA INFILE failing with commas
body: <p>Here's the statement:</p>
  <pre><code>LOAD DATA INFILE '/var/lib/mysql-files/test.csv'
  INTO TABLE test 
  FIELDS TERMINATED BY ',' ENCLOSED BY '&quot;' ESCAPED BY '\\' 
  </code></pre>
  <p>Here's a line that imports fine:</p>
  <pre><code>1450327840667357185, 1, &quot;This is my text&quot;
  </code></pre>
  <p>If the text field has a comma though, it fails.  For example, see this line:</p>
  <pre><code>1450327840667357185, 1, &quot;This is my text, with a comma in it&quot;
  </code></pre>
  <p>Why does it fail?</p>
  <p>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?</p>
  <p>If I have to reprocess all the text to quote comma's, it would be a big task.</p>