MySQL批量修改表前缀
示例原前缀:old_
示例新前缀:new_
代码示例:
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO new_',
substring(table_name, 4),
';'
)
FROM
information_schema. TABLES
WHERE
table_name LIKE 'old_%';