王新阳

SELECT 'SET FOREIGN_KEY_CHECKS = 0;'
UNION
SELECT CONCAT( 'drop table ', table_name, ';' )
FROM information_schema.tables
WHERE table_schema='数据库名' AND table_name LIKE '表前缀%'
UNION
SELECT 'SET FOREIGN_KEY_CHECKS = 1;'

复制生成的结果，执行之！