批量修改数据库表名前缀

SELECT
	CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO mydb_', substring( table_name, 4 ), ';' ) AS `sql语句` 
FROM
	information_schema.TABLES 
WHERE
	table_name LIKE 'db_%';