可以瞬间将大表从当前库,迁移到其他库
SELECT CONCAT("RENAME TABLE cloud_followup_hxey.`",TABLE_NAME,"` TO cloud_followup_v25.",TABLE_NAME,";")AS target_tables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="cloud_followup_hxey"
AND TABLE_TYPE="BASE TABLE"
SELECT CONCAT("RENAME TABLE cloud_followup_hxey.`",TABLE_NAME,"` TO cloud_followup_v25.",TABLE_NAME,";")AS target_tables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="cloud_followup_hxey"
AND TABLE_TYPE="BASE TABLE"