如何批量修改数据表名子

本示例说明: 数据库名：edu ,原表前缀：dc_，目前表前缀：oa_

第一步：查询表名称

select table_name FROM information_schema.tables where TABLE_SCHEMA = 'edu';

第二步：确认表名称

select table_name FROM information_schema.tables where TABLE_SCHEMA = 'edu' and table_name like 'dc_%';

第三步：生成SQL语句

Select CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO oa_', substring(table_name,4 ),';' ) as renamesql FROM information_schema.tables Where table_name LIKE 'dc_%';

第四步：拷贝SQL并执行

ALTER TABLE dc_order RENAME TO oa_order;
ALTER TABLE dc_user RENAME TO oa_user;