SELECT
CONCAT(
‘ALTER TABLE ‘,
table_name,
‘ RENAME TO db_‘,
substring(table_name, 4),
‘;‘
)
FROM
information_schema. TABLES
WHERE
table_name LIKE ‘ct%‘;原文：https://www.cnblogs.com/lty-fly/p/11687354.html