Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
04-21-2012, 06:35 PM #1
- Join Date
- Apr 2012
- Thanked 0 Times in 0 Posts
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
04-23-2012, 09:07 PM #2
CSV will be easier than XML.
One *POSSIBLE* example:
That should work for a CSV file that looks something likeCode:LOAD DATA INFILE '...your file name' INTO TABLE ...yourTableName... FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.