删除以某字符串开头的表

SELECT CONCAT('drop table ', table_name, ';')
FROM information_schema. TABLES
WHERE table_name LIKE 'xxx_%';