Looking for simple tool to execute sql statements on multiple identical databases

Blake Girardot <[email protected]> Fri, 16 Mar 2007 14:11:32 -0400
Newsgroups gmane.comp.db.mysql.mycc
Message-ID <[email protected]>
Hi,

I am looking for a very simple way to execute the same sql statements on 
multiple MySQL databases with identical schemas. I don't need to access 
different mysql servers, just different databases served up by my one 
mysql server. I also don't need them to run at the same time, just a 
methodical running of each set of sql statements on several different 
databases.

I want to select from the list of databases the user who is used to 
connect to the mysql server. Check boxes or a multiple select list type 
of thing.

And then a large text area where I can paste in 1 or more mysql 
statements (selects, updates or inserts) and have those sql statements 
sent to each database I checked off in the list. I don't need it to 
build the statements for me or anything, I will fine tune them at the 
command line and get them ready to be run across all the databases I select.

The results would just be displayed and/or logged for display after they 
were executed.

I have looked at a number of GUI tools and none really seemed to fit my 
simple requirements or I didn't understand how to make them do that or 
something like it.

Any suggestions? It sounds pretty easy to write something like this in 
PHP, but I am not a programmer so it is beyond my skills to do that.

Pointers to software you think can do it are great, if I know I can do 
it somehow in a package I will work on it until I get it figured out.

I would also be glad to pay someone to write some PHP to do it if there 
isn't a reasonable alternative already existing.

Regards,
BG

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]