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
Reputation Points: 15
Solved Threads: 0
Junior Poster in Training
Offline 50 posts
since Mar 2005
Unsolved 
