mysql批量删除某一类规律的表

 1.mysql批量删除某一类规律的表

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

执行以上sql时,将数据库名换成你自己的数据库名即可.之后会生成drop语句会如下所示,最后再将生成的drop语句执行便是

2.mysql批量删除某一类规律的表数据

SELECT CONCAT
('delete from ' , table_name,';') 
FROM 
information_schema.tables 
WHERE 
table_schema LIKE '数据库名'
AND table_name LIKE 'b_t_%';

 

参考文章:https://blog.csdn.net/a545132569/article/details/89227601