04, I try to load the csv file into the database, but it gives an error
my file upload code
LOAD DATA LOCAL INFILE '//home//triveni//Documents//test.csv' INTO TABLE 1981_5 FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' (question,answer1,answer2,answer3,answer4,answer5,answer6,rightAnswer,Marks)
and data in the file
Whartsdf,dsfds,sdfdsf,sdfdsf,sdfds,sdf,fsdf,2,2
Any One Please help me, I tried all the features, changed privileges, I tried only LOAD DATA INFILE But I got a solution ...
And its work is good in Windows. Is this an OS problem?
source share