若表有相同的前缀,则先构造出删除表的查询语句,然后进行批量删除:
SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(table_name) , ';') AS statement FROM information_schema.tables WHERE table_name like 'test_%';
若表有相同的前缀,则先构造出删除表的查询语句,然后进行批量删除:
SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(table_name) , ';') AS statement FROM information_schema.tables WHERE table_name like 'test_%';