MySQL Forums
Forum List  »  InnoDB

Alter table across muliple db's with almost same name
Posted by: Jeff Posth
Date: December 26, 2015 02:52AM

I am wanting to make a change on a multi tenant app that has 1 database per customer. They all have the same name but has a unique number at the end of the name to identify like "test121, test122, test123' etc. Is there a way to script across all db that have "test" in the name to then run an alter on a table? Im having trouble finding a good tutorial out there and am sure my search terms are probably off. Thank you in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Alter table across muliple db's with almost same name
1479
December 26, 2015 02:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.