Need help with table export.

[EdLentz]

I need to export a table and I can't seem to get it right. Here is what I need: All fields separated by a comma , all fields enclosed by "" and if a field has either a Null of a nothing in it I need some kind of character either a 0 or o. I can get some of what I want using PHPMyAdmin but I can't seem to get the rest. Can someone help? Is there another MySql Admin program that will let me manipulate the export?

Thanks

 

[QatQat]

select, field1, replace(field2, '', 'o') from table1 into outfile /home/youruser/yourfile.txt fields enclosed by "

or something similar

Cheers

QatQat

Life is what happens when you are making other plans.

 

[QatQat]

probably my SELECT ... INTO OUTFILE syntax is a bit approximate,

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/SELECT.html

better if you check it in the link above.

Cheers

QatQat

Life is what happens when you are making other plans.