[SOLVED] csv to mysql.....

[popmotsy]

hii to all.....

 

I wanna code to import and export csv file to mysql without using PHPMYADMIN,,,,,I wanna a code for that,,,can anyone help me out this problame.... :-[

 

thanks,,,,,

[Scorpy]

To save into a CSV:

SELECT * INTO OUTFILE 'filename.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM ? 

 

To load from:

LOAD DATA INFILE 'filename.csv' REPLACE INTO TABLE ? FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' 

 

The replace is optional, just depends if you want it to change existing rows.