---单独更改某个表名或者表前缀的语句是：

ALTER TABLE `old_xxxxx` RENAME TO `new_xxxxx`;

---首先执行以下语句生成

SELECT CONCAT('ALTER TABLE ',table_name,' RENAME TO new',substring(table_name,4),';')

FROM in information_schema.tables

WHERE table_name LIKE 'old_%'

---这样就会得到类似以下的结果

ALTER TABLE old_xxxxx RENAME TO new_xxxxx;

ALTER TABLE old_yyyyy RENAME TO new_yyyyy;

ALTER TABLE old_zzzzz RENAME TO new_zzzzz;