Importing CSV to MySQL with Load Data Infile?

Valid syntax is LOAD DATA INFILE 'c:/worldminwage. Csv' INTO TABLE tablename .

Up vote 0 down vote favorite share g+ share fb share tw.

I'm trying to load a CSV file into MySQL, and I keep getting syntax errors: load data infile 'c:/worldminwage. Csv' fields terminated by ',' enclosed by '"' lines terminated by '\n' (YearlyWage, PercentGDP, Date effective); Can anyone help me get this working? Thanks.

Sql mysql csv import load-data-infile link|improve this question edited Dec 19 '10 at 23:39OMG Ponies95.2k1065138 asked Dec 19 '10 at 23:29MarathonStudios36218 73% accept rate.

Valid syntax is LOAD DATA INFILE 'c:/worldminwage. Csv' INTO TABLE tablename. You forgot to mention which table the data should go in.

See dev.mysql.com/doc/refman/5.1/en/load-dat....

Thanks, got it working – MarathonStudios Dec 20 '10 at 6:33.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.