MySQL批量删除指定前缀表

Select CONCAT( 'drop table ', table_name, ';' )  

FROM information_schema.tables  

Where table_name LIKE 'dede_%';

转载于:https://blog.51cto.com/aaronsa/1741505