title: MySQL "LOAD DATA INFILE" and Missing Double Quotes
body: <p>I'm trying to load a CSV into MySQL using the LOAD DATA INFILE technique.  It's working fine, but I have a problem where some columns use double quotes and some do not.</p>
  
  <p>Example:</p>
  
  <pre><code>something,123,something,"Bauer, Jack",123,something
  </code></pre>
  
  <p>What happens is the commas inside the quotes break the import, so my data is all jacked up at the end.  Not sure how to get the import to escape commas inside the double quotes.</p>
  
  <pre><code>mysql --user=&lt;USER&gt; --password=&lt;PASS&gt; -e "LOAD DATA INFILE '&lt;FILENAME&gt;' INTO TABLE &lt;TABLENAME&gt; FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (col1, col2, col3, ...)" &lt;DATABASE&gt;
  </code></pre>