mysql批量删除表,沟通前缀的表

Select CONCAT( 'drop table ', table_name, ';' ) from information_schema.tables where table_name like '表前缀%' and table_schema = '表名'
查询出来的功效，复制到查询器里批量执行一下就行了~~~