删除以某字符串开头的表 SELECT CONCAT('drop table ', table_name, ';') FROM information_schema. TABLES WHERE table_name LIKE 'xxx_%';