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]

Reply via email to