Mysql 批量删除表名
select concat('drop table ', TABLE_NAME, ';') from information_schema.`tables` where TABLE_NAME like '%_copy1';
MYSQL批量修改表前缀与表名sql语句
SELECT
CONCAT(
'ALTER TABLE ',
table_name,
' RENAME TO ',
substring_index(table_name, '_copy1', 1),
';'
)
FROM
information_schema. TABLES
WHERE
table_name LIKE '%_copy1';
