Create a MySQL SELECT query to select the data you want to output to CSV. Specify the output file and the four CSV options: "FIELDS TERMINATED BY" specifies the character used between fields ...

but here's what I'm trying to do:<BR><BR>I need to run a script on a central workstation that will run a query on two remote MySQL boxes and return the output of that query to two text files on ...

When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert tab characters into the output data stream ...

I have a MySQL table that has events in it ... make it obvious what table a column is coming from. Besides making your query more readable, it ensures the column actually exists - if a column ...