25 databases with the SAME query? Sounds like the database structure
are pretty similar. Perhaps you want to look into merge tables or
unions.
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
> 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.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
