批量删除指定前缀的所有mysql表:
SET @tables = NULL;
SELECT GROUP_CONCAT('`', table_name, '`') INTO @tables
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
AND table_name LIKE 'aaa\_%';
SET @query = CONCAT('DROP TABLE IF EXISTS ', @tables);
PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;