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/[EMAIL PROTECTED]



--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to