From Kb_JMY(晉明夷)

• MySQL Commands

How to add prefix for 20 tables?

• Ref: forums.mysql.com: What is the command to add the prefix for the 20 tables of my database? 12/18/2006 08:31PM

• Here is the solution per the Ref:

SELECT CONCAT(
'ALTER TABLE ', TABLE_NAME,
' RENAME TO en_', TABLE_NAME, ';') AS my_queries
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'your_database'