Mysql数据库批量删除数据表操作

https://blog.csdn.net/a463620704/article/details/104846581/

使用

Select CONCAT( 'drop table ', table_name, ';' ) FROM information_schema.tables Where table_name LIKE '__prefix_%';

可生成drop表语句,然后可以批量删除:

drop table __prefix_20180129;

drop table __prefix_20180130;

drop table __prefix_20180131;