批量删除表结构 固定前缀

MYSQL · 01-09
SELECT CONCAT('drop table ', group_concat(TABLE_NAME), ';') FROM information_schema.`TABLES` WHERE table_schema = 'db_name' AND TABLE_NAME LIKE 'prefix_%';
删除
Theme Jasmine by Kent Liao