title: SQL bulk insert CSV syntax error?
body: <p>I'm trying to load up a simple CSV file using <a href="http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/" rel="nofollow">this tutorial</a>. My CSV includes the list of nationalities, of which here is a sample:</p>
  
  <p><code>1,Afghan,2015-10-14 17:56:39</code></p>
  
  <p>Meanwhile, my table definitions is:</p>
  
  <pre><code>+-------------+--------------+------+-----+-------------------+-----------------------------+
  | Field       | Type         | Null | Key | Default           | Extra                       |
  +-------------+--------------+------+-----+-------------------+-----------------------------+
  | ID          | int(11)      | NO   | PRI | NULL              | auto_increment              |
  | Nationality | varchar(255) | NO   | UNI | NULL              |                             |
  | Time        | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
  +-------------+--------------+------+-----+-------------------+-----------------------------+
  </code></pre>
  
  <p>I'm running the following command:</p>
  
  <p><code>BULK INSERT meta_nationality FROM '/home/benjamin/Downloads/Nationalities.csv' WITH (fieldterminator = ',', rowterminator ='\n');</code></p>
  
  <p>This seems to be right, however I get an error message pointing to a syntax issue:</p>
  
  <p><code>ERROR 1064 (42000): 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...</code></p>
  
  <p><a href="https://dev.mysql.com/doc/refman/5.6/en/keywords.html" rel="nofollow">According to the documentation</a> the syntax error refers to the use of a reserved word, but I wouldn't know which one it is in this case.</p>
  
  <p>Could you help me figure out my way through this? Thanks.</p>