Export MySQL data to a tab-delimited spreadsheet
This data export script has turned out to be quite useful for me. Assuming that others might also find uses for it, I'm sharing the source code. If you have the need to export MySQL data to a tab-delimited spreadsheet, then the Data Export Utility is for you!
March 14th, 2007 at 10:40 am
Cool script Sam!
I'll be adding this to my little collection of utilities
Handy for debuging and the like…
Kalan
March 14th, 2007 at 12:39 pm
Thanks Kalan! I've been using this predominantly to export user contact info for marketing campaigns, but I imagine I'll find many more uses for it, and I hope you do too!
July 15th, 2007 at 4:37 pm
[…] Found a short script today and thought others here might find it useful. It connects to your MySQL server and exports a table as a tab delimited text file. Great if you're trying to import your MySQL data into another program where normal SQL may not work. […]
August 17th, 2007 at 4:29 pm
thanks a bunch. awesome script and worked flawlessly for me
August 22nd, 2007 at 9:16 am
Thank you Sam! Was having trouble getting the data to populate correctly! I see now where my issue was. You have saved me a mornings worth of trial and errors. Thank you again!