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; -- 老库
mysql 改库名
最新推荐文章于 2023-11-28 17:43:01 发布