SELECT CONCAT( ‘drop table ‘, table_name, ‘;‘ ) FROM information_schema. TABLES WHERE table_schema = ‘dbname‘ AND table_name LIKE ‘sth_%‘;
批量删除指定表
原文：https://www.cnblogs.com/codeaaa/p/9139159.html
