mysql 批量替换表前缀方法

SELECT
    CONCAT(
        'ALTER TABLE ',
        table_name,
        ' RENAME TO i_',
        substring(table_name, 4),
        ';'
    )
FROM
    information_schema. TABLES
WHERE
    table_name LIKE 'yy%';



SELECT
a.*,
concat(
'alter table ',
a.TABLE_NAME,
' rename ge_',
SUBSTR(
a.TABLE_NAME
FROM
INSTR(a.TABLE_NAME, '_') + 1
),
';'
)
FROM
information_schema.`TABLES` a
WHERE
a.TABLE_SCHEMA = 'shiye';