Have Geek Brain

BULK INSERT problem in MySQL

I am getting 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 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
+2


a source to share


2 answers


Use LOAD DATA INFILE insteadBULK INSERT



+2


a source


LOAD DATA INFILE 'd: faculty.csv' INTO TABLE libra.faculty FULL TERMS ',' LINES INTERRUPTED '\ n'



0


a source






More articles:


All Articles