The MySQL Archive

Output MySQL query results to XML from the command prompt

In a previous tutorial I wrote about the ability to export MySQL query results out to a CSV file via the command prompt. There is another method for getting your query results into a file without using a server-side language, and it involves command line startup options. In this example I will push the results to XML, although an HTML option is available as well. Continue reading.

Export data to a CSV file using only the MySQL command prompt

Recently our marketing department has been running a series of promotions as contests. The system is setup to receive entries, but for the present time we will not be building an administration interface. The entries will instead be extracted into a CSV file manually when the contest deadline has passed. Up until this point I was unaware that MySQL could perform the task sans server-side language at the command prompt. Continue reading.