Sunday, April 17, 2005

Export from mysql into fixed length file

SELECT * INTO OUTFILE file_name
FIELDS TERMINATED BY '' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY "\n"
FROM my_table;

No comments: