25 databases with the SAME query? Sounds like the database structure
are pretty similar. Perhaps you want to look into merge tables or
On Aug 16, 2004, at 12:58 PM, David Mohorn wrote:
> I have about 25 databases that I need to run the same query against
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments