select concat(‘drop table ‘,table_name,‘;‘) from information_schema.tables where table_schema=‘employees‘ and table_name rlike ‘^d.*$‘ into outfile ‘d:/b.sql‘;
MySQL 批量删除表
原文：https://www.cnblogs.com/dissipate/p/14768068.html
