Exporting as fixed length file 1

[ianicr]

Hi all
I have an address db stored in mysql. I have no problems exporting as a csv file but need to export it as fixed width fields with no delimiters etc. Anyone know if theres a way to do this in MySQL?
Thanks

 

[hvass]

You can pad the fields with blanks to a fixed width then specify terminiated by '' in your outfile statement

 

[ianicr]

Is there an easy way of doing this? and could you please let me know the syntax you would use?

Thanks

 

[hvass]

This is the easy way to do this -

select
rpad(fielda,20," &quot,
lpad(fieldb,10," &quot
from mytable
into outfile '/home/me/fixedlengthoutput.txt'
fields terminated by ''
lines terminated by '\n';

http://www.mysql.com/doc/en/String_functions.html

http://www.mysql.com/doc/en/SELECT.html

http://www.mysql.com/doc/en/LOAD_DATA.html