SQL bulk insert CSV syntax error?

Question

I'm trying to load up a simple CSV file using this tutorial. My CSV includes the list of nationalities, of which here is a sample:

1,Afghan,2015-10-14 17:56:39

Meanwhile, my table definitions is:

+-------------+--------------+------+-----+-------------------+-----------------------------+
| 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 |
+-------------+--------------+------+-----+-------------------+-----------------------------+

I'm running the following command:

BULK INSERT meta_nationality FROM '/home/benjamin/Downloads/Nationalities.csv' WITH (fieldterminator = ',', rowterminator ='\n');

This seems to be right, however I get an error message pointing to a syntax issue:

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...

According to the documentation the syntax error refers to the use of a reserved word, but I wouldn't know which one it is in this case.

Could you help me figure out my way through this? Thanks.

The tutorial you're following is for SQL Server, not MySQL. Syntax differs significantly between the two. — Sculper
– Sculper, Commented Oct 15, 2015 at 15:49

SeeSharp · Accepted Answer · 2015-10-15 15:46:23Z

1

Since you're using MySQL you'll want to use a different syntax. You should be aware that the tutorial you're following is for MSSQL.

LOAD DATA INFILE "/home/benjamin/Downloads/Nationalities.csv"
INTO TABLE meta_nationality
COLUMNS TERMINATED BY ','
LINES TERMINATED BY '\n'

answered Oct 15, 2015 at 15:46

SeeSharp

2,80017 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mr. Llama · Accepted Answer · 2015-10-15 15:45:29Z

0

BULK INSERT isn't a command.

You were probably looking for LOAD DATA INFILE _____ INTO TABLE _____

answered Oct 15, 2015 at 15:45

Mr. Llama

21k3 gold badges70 silver badges121 bronze badges

Comments

Adarsh · Accepted Answer · 2015-10-15 15:57:46Z

0

Please refer MySQL tutorials instead of SQL server. LOAD DATA INFILE command will help you

answered Oct 15, 2015 at 15:57

Adarsh

7244 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQL bulk insert CSV syntax error?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related