title: importing csv file directly into phpmyadmin
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/6169562/invalid-field-count-in-csv-input-on-line-1">Invalid field count in CSV input on line 1</a>  </p>
  </blockquote>
  
  
  
  <p>When I go to phpmyadmin and after selecting the database and the table which I want when I click on "import". And that when I click on "GO" then it produces the error </p>
  
  <blockquote>
    <p>Invalid field count in CSV input on line 1.</p>
  </blockquote>
  
  <p>So how can I import my csv file directly into mysql database.</p>
  
  <p>I have tried with</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'C:\Users\ah\Documents\mathema_utf8.csv'
      INTO TABLE subject3
      FIELDS TERMINATED BY ','
      LINES TERMINATED BY '\n' IGNORE 1 LINES (col1, col2, col3, col4)
  </code></pre>
  
  <p>But it produces the error</p>
  
  <blockquote>
    <p>#7890 - Can't find file 'C:UserspratibhaDocumentsmathema_utf8.csv'.</p>
  </blockquote>
  
  <p>So what should be the name of the file.</p>