mysql < CSV < mydql

[ashneet]

What i am trying to do is to extract data from mysql table into a .CSV file and then after editing upload it again to update my DB.

I am planning on using php but i at the time dont know which command will convert mysql table into .CSV and insert/overide the old info in the table from CSV.

[barnamos]

from mysql docs under the SELECT syntax:

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;

Then you can use the LOAD DATA syntax:

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

HTH

[ashneet]

Thanks, That helps