mysql批量修改表前缀

修改表名

SELECT
CONCAT(
    'ALTER TABLE ',
    table_name,
    ' RENAME TO b_',
    substring( table_name, 2 ),
    ';' 
) 
FROM
information_schema.TABLES 
WHERE
table_name LIKE 'a_%';