I have a fixed width file that I am loading into mysql on a daily basis. The data gets updated during the day in the mysql db, and then at the end of the day, I need to export it back to a fixed width file so that it can be imported into an alpha machine running VMS. When I do a "select * into outfile 'filename.txt' from tablename" everything looks great except mysql fills the spaces with a tab rather than spaces. I need the extra "padding" in the field to be spaces. Any ideas on how I can do that?
Thanks,
Jerod
