批量修改表前缀

时间：2020-01-28 17:37:21 收藏：0 阅读：84

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/hl15/p/12238366.html