title: Correct Syntax for CSV import to SQL MAMP Powered Database
body: <p>I am running MAMP on my local machine, and using this command for an import works successfully but it is throwing an error on my syntax. </p>
  
  <pre><code>/applications/MAMP/library/bin/mysql -u testtest -p test &lt; /Users/myName/info.csv 
  </code></pre>
  
  <p>I have been importing/exporting a lot of CSV's into different databases and have noticed that the syntax is slightly different for different DBs, and giving errors sometimes with or without quotes etc. I'm wondering if someone could explain this to me, and what may be the problem in this particular case as this is the format my CSV export came in when I exported it using a Drupal UI.</p>
  
  <pre><code>ID,First,Last,e-mail,Points,kID,gID,fID,tID,rID
  "45","mark","brown","test@test.com","234","","34","","532",""
  "353","sam","harris","newtest@test.com","343","3432","","43","","87"
  </code></pre>
  
  <p>I am getting this error which is why I think this</p>
  
  <pre><code>ERROR 1064 (42000) at line 1: 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 'ID,First,Last,e-mail,Points,kID,gID,f' at line 1
  </code></pre>