MySQL 批量删除表

    

 

 

 

select concat('drop table ',table_name,';') from information_schema.tables where table_schema='employees' and table_name rlike '^d.*$' into outfile 'd:/b.sql';

 

 

 

 

 

 

posted @ 2021-05-14 12:21  ascertain  阅读(185)  评论(0编辑  收藏  举报