title: mysql load data infile it contain more data than there were input column
body: <p>I'm a new to mysql, I try load csv file to mysql.
  the csv like:</p>
  
  <pre><code>1,"a,b"
  2,bc
  3,d
  </code></pre>
  
  <p>the table like this: </p>
  
  <pre><code>create table test(ind varchar(10),var varchar(20));
  </code></pre>
  
  <p>when I load this csv file:</p>
  
  <pre><code>load data infile 'test.csv' into table test
  fields terminated by ',' ;
  </code></pre>
  
  <p>I change this 
  the warning:</p>
  
  <blockquote>
    <p>row 1 was truncated: it contained more data than there were input columns
    I try this:</p>
  </blockquote>
  
  <pre><code>load data infile 'test.csv' into table test
  fields terminated by ','
  optionally enclosed by '"'
  </code></pre>
  
  <p>it doesn't work.</p>
  
  <p>the common of "a,b" cause this error. but I don't know how to solve this question. </p>