View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 09:32 AM
tyler.style@gmail.com
 
Posts: n/a
Default non-tab delimited output?

I have a decidedly ugly problem...I really want output with NO
delimiters whatsoever for specialized legacy systems reasons. Can
anyone tell me if it's possible to get mysql to return results without
the tabs? On a WindowsXP box, I am currently using:

mysql -uexport -pxxxx --force -N hh < c:\batch\getFedexFrom.sql >
P:\ship\FEDEX\fedexFROM.txt

where getFedexFrom.sql is simply

select * from hh.fedexfrom

I'd rather do it all from mysql if possible, rather than having to do a
2nd sweep with some kind of awk.

Any suggestions would be much appreciated!

Tyler Style



tyler AT
healthy habits web
DOT
com

Reply With Quote