Hello, I've read documentation and looked in the list archives but haven't found anything that specifically addresses the idea of writing out fields in a fixed-field format.
I'd like to do something like "SELECT id,date INTO OUTFILE 'data.txt' id = column 1, date = column 10;" to get a file that looks like: 1001 2003-01-16 1002 2003-01-15 2003 2003-01-16 I can certianly just dump it out comma delimited and then parse that file, or maybe make perl do it all for me, but before I did that I wanted to ask if MySQL can just do it itself. Thanks a lot, Eric -- --------------------------------------------------------------- Eric White [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php