I have about 25 databases with the same structure and occasionally need
to update the table structure. For example, I recently found a mistake
in a field that was of type SET and needed to be VARCHAR. I will now
need to edit each table. Is there an easy method to alter table
structure across multiple dbs as opposed to editing each one individually?
In retrospect I should have combined them into one db and may consider
doing that.
All dbs start with 'pm_' and have identically named tables
MySQL 5.0.18
Windows 2003
Thank you,
--
*Jason Dimberg*
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]