CREATE DATABASE tech_baseline_marketing_auto_bus_01; -- 新库
SELECT
CONCAT('RENAME TABLE tech_baseline_marketing_auto_bus_00.',TABLE_NAME,' TO tech_baseline_marketing_auto_bus_01.',TABLE_NAME,';') DDL
FROM
information_schema.`TABLES`
WHERE
TABLE_SCHEMA = 'tech_baseline_marketing_auto_bus_00';
DROP DATABASE tech_baseline_marketing_auto_bus_00; -- 老库
02-07
175