Why when I import CSV file into MySQL rows are cut off after keywords? -
i trying import csv file following sample row:
//,/dona paula estate malbec/,/malbec argentina, south america/,
into mysql database, after "from" skipped in table. think because sql keyword. enclosing fields '/' not help. can me this? appresiate it!
table wine (wineid, winename, winedescription); wineid primary key (autonmber).
my sql statement is:
load data local infile 'wines.csv' table wines fields terminated ',' enclosed '/' lines terminated '\r\n' ignore 1 lines (wineid, winename, winedescription);
Comments
Post a Comment