BULK INSERT problem in MySQL
I get an error with the following SQL command for bulk insert.
BULK INSERT libra.faculty
FROM 'd\:faculty.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
);
Here's the error message:
ERROR 1064 (42000): You have an e开发者_开发问答rror in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'BULK
INSERT libra.faculty
FROM 'd:\faculty.csv'
WITH
(
FIELDTERMINATOR = ',',
RO' at line 1
Use LOAD DATA INFILE instead of BULK INSERT
LOAD DATA INFILE 'd:faculty.csv' INTO TABLE libra.faculty FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
精彩评论