mysql之批量修改表名前缀

1. 假设修改数据库下前缀一致的表明更改为另一种前缀的表名

SELECT 
    table_name,
    CONCAT("ALTER TABLE ", table_name, " RENAME TO ", REPLACE(table_name, 'ai_', 'bi_')) AS rename_statement
FROM 
    INFORMATION_SCHEMA.TABLES
WHERE 
    table_schema = 'ai_user'
    AND table_name LIKE 'ai%'
ORDER BY 
    table_name;

执行结果如下

拷贝rename_statement列的数据执行语句即可