select concat('drop table ',table_name,';') from information_schema.TABLES where table_schema='test'; 然后执行此语句运行后的结果即可