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]