I revert to this mailing list to ask for help accomplishing a specific task.
I'll try to explain as best I can.
Say I have a DB named... well... "database1", this db has the following
What I want to do is copy each of the tables (exactly as they are, including
primary keys, data, etc) but at the same time change the prefix to something
else (ie: eng_) so that I would end up with:
en_table1 (exact copy of pt_table1, including data PK, FK, etc..)
en_table2 (exact copy of pt_table2, including data PK, FK, etc..)
en_table3 (exact copy of pt_table3, including data PK, FK, etc..)
Anyway of accomplishing this? Ideally without having to state each of the
tables names. And also that this would work so that you could only duplicate
tables that have a certain prefix, so: duplicate only tables that start with
"pt_" and change prefix to "es_" for example.
Any help or point in the right direction will be much apreciated!
View this message in context:
Sent from the MySQL - General mailing list archive at Nabble.com.