Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Automate table name modifications
Thanks.
I have forwarded your issue to my development team.
I should have been more explicit — by modification I mean not only adding a string to a name (in front or end of an existing name) but also removing it too. This would make it easier to move from one host to another.
We need to use Alter Table… SQL to modify information about tables. There is no option in Alter Table to work on multiple tables.
I don't think it' common that you should use a prefix with each table – just the database and the user(s)
My provider requires it, and they claim having tens of thousands of clients. Perhaps, this is common enough to justify adding this feature to SQLyog.