mysql批量删除表名符合条件的表

SELECT CONCAT ('drop table ' , table_name,';') FROM information_schema.tables WHERE table_schema LIKE '库名' AND table_name LIKE '%表名%';