csv - BULK INSERT problem in MySQL -

csv - BULK INSERT problem in MySQL -

September 15, 2014

I get an error with the following SQL command for bulk input.

  Bulk INSERT Libra .faculty FROM with 'd \: faculty.csv' (FIELDTERMINATOR = ',', ROWTERMINATOR = '\ n');

Here is the error message:

  Error 1064 (42000): There is an error in your SQL syntax; Check the manual that is near the correct syntax for your syntax, with the 'BULK INSERT Libra.faculty FROM' d: \ faculty.csv '(FIELDTERMINATOR =', 'RO' on line 1  << Code> Bulk INSERT

html>

Comments