BULK INSERT problem in mysql
- by kartiku
Hi, I get an error with the following sql command for bulk insert....any help would be appreciated.
BULK INSERT libra.faculty
FROM 'd\:faculty.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
);
Here's the error message
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 libra.faculty
FROM 'd:\faculty.csv'
WITH
(
FIELDTERMINATOR = ',',
RO' at line 1
