link

jamhussain · 04-21-2012, 05:35 PM

I m new in mysql.
I have a csv or xml file having fields
country name, birth rate, year,

i want to upload this file into mysql database.
can anybody provide me link to solve this problem
thanks.

Old Pedant · 04-23-2012, 08:07 PM

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

CSV will be easier than XML.

One *POSSIBLE* example:

Code:

LOAD DATA INFILE '...your file name'
INTO TABLE ...yourTableName...
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

That should work for a CSV file that looks something like

Code:

"England",1.03,2001
"France",0.97,2001

etc.