I have SSH access to the SQL servers and that's about it. <BR><BR>Right now it's an ugly manual process where you: SSH to SQL box1, run the SQL query and dump the output to a text file, FTP the ...

For example, type "mysql -u root -p" (without the quote marks) and enter your password when prompted. Create a MySQL SELECT query to select the data you want to output to CSV.

I have a SQL query that will get me all the data I want for the upcoming events, but I don't know how to split up the results by month. Here is the query I have: ...

Written for MySQL 5.0/5.1 but still doing a great job of covering the still popular MySQL 4.1, this book brings the recipes of the first version up to date and adds many more. It also covers using ...

You can create a new SAS, DB2, or other database management system table from your output; see Creating New Tables for details You can save the SQL query to a catalog entry of type SQL. You can save ...