SELECT CONCAT( ‘DROP TABLE ‘, GROUP_CONCAT(table_name) , ‘;‘ ) AS statement FROM information_schema.tables WHERE table_schema = ‘video‘ AND table_name LIKE ‘t_c%‘;
mysql批量删除数据库表
原文：http://www.cnblogs.com/liadmin/p/6360978.html
