SQL语句:
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO db_',
substring(table_name, 4), ';' ) FROM information_schema. TABLES WHERE table_name LIKE 'ct%';
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO db_',
substring(table_name, 4), ';' ) FROM information_schema. TABLES WHERE table_name LIKE 'ct%';