Why BULK insert gives syntax error of expecting eof

Asked May 21 '20 at 05:27

Active May 21 '20 at 06:31

Viewed 157 times

I want to insert large number of rows from csv into sql database but when I use the code below

BULK INSERT Sales
FROM 'C:\1500000 Sales Records.csv'
WITH (FIRSTROW = 2,
    FIELDTERMINATOR = ',',
    ROWTERMINATOR='\n' );

It gives the following error

BULK is not valid at this position, expecting EOF, ';' I am using MYSQL8.0 DB and first I created table with create table command and then I was trying to bulk insert the data from csv

edited May 21 '20 at 06:31

asked May 21 '20 at 05:27

Pankaj Garg

1

is this code part of a script with others commands?? and which db you are really using ?? which version? – scaisEdge May 21 '20 at 05:59
I am using MYSQL8.0 DB and first I created table with create table command and then I was trying to bulk insert the data from csv – Pankaj Garg May 21 '20 at 06:31
1

The mysql version of bulk insert is https://dev.mysql.com/doc/refman/8.0/en/load-data.html – P.Salmon May 21 '20 at 07:38
But it is slow. I tried inserting 400k+ rows and it took more than 4 hours to insert – Pankaj Garg May 21 '20 at 08:20
For improving performance of load data refer this -> https://stackoverflow.com/questions/2463602/mysql-load-data-infile-acceleration – Nishant Gupta May 21 '20 at 08:40

Why BULK insert gives syntax error of expecting eof

0 Answers0