title: How to bulk insert a csv file?
body: <pre><code>BULK INSERT krissmall
  FROM 'C:\Users\Administrator\Downloads\misskrisdata_small.csv'
  WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
  </code></pre>
  
  <p><strong>ERROR 1064 (42000)</strong>: You have an error in your SQL syntax; check the manual that
  corresponds to your MySQL server version for the right syntax to use near 'BULK
  INSERT krissmall FROM 'C:\Users\Administrator\Downloads\misskrisdata_small.' at
  line 1</p>
  
  <p>Can someone please tell me where went wrong? Or some other reasons behind this. I stared at this query for a long time, and looked it up a lot but I cannot find where it is wrong.</p>