Hi, > 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 > tables: > > pt_table1 > pt_table2 > pt_table3 > > 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: > > pt_table1 > pt_table2 > pt_table3 > 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!
It seems you're trying to create something multi-lingual, would that be correct? If so, why not design proper metadata so you don't have to copy tables AND modify your queries. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
