From: Martijn Tonies
Date: August 16 2004 5:06pm
Subject: Re: Database Stats
List-Archive: http://lists.mysql.com/mysql/171036
Message-Id: <04ab01c483b3$6ff701e0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> I have about 25 databases that I need to run the same query against that
> returns about 5 columns of information.
>
> I need this information then published within an Excel spreedsheet.
>
> What is the best way do handle this?
>
> Currently, I'm running each query manually, copying/pasting the result
> to Excel, and repeating...
>
> I need to run this procedure every week, and it takes a considerable
> amount of time.

In that case, I suggest automating it with a small program.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com