批量删除表结构 固定前缀

MYSQL  ·  2024-01-09

SELECT CONCAT('drop table ', group_concat(TABLE_NAME), ';') FROM information_schema.`TABLES` WHERE table_schema = 'db_name' AND TABLE_NAME LIKE 'prefix_%';