Well I’ve been spinning my wheels for 3 hours now, and my first post got deleted somehow so I’m not a happy camper at the moment. I’m trying to create an automated weekly data export to a text file from a MySql database and it’s not going well. I have found very little usefull documentation regarding output formatting for doing this. My main issues right now are including column titles, and not writing the string “\N” for every null value in the database, I want it to just write and empty string.
I have a MySql GUI called Navicat which allows me to export the data in the exact structure I want, however it does not allow me to select a Date range, so I have to dump everything and then manually go through and delete the stuff I don’t want which is subject to user error.
How great would it be to live in a world without Databases, I would never miss messing with them.
