Effacer plusieurs tables MySQL ayant un même préfixe

gistfile1.txt

-- Set up variable to delete ALL tables starting with 'temp_'
SET GROUP_CONCAT_MAX_LEN=10000;
SET @tbls = (SELECT GROUP_CONCAT(TABLE_NAME)
            FROM information_schema.TABLES
            WHERE TABLE_SCHEMA = 'my_database'
            AND TABLE_NAME LIKE 'temp_%');
SET @delStmt = CONCAT('DROP TABLE ',  @tbls);
-- SELECT @delStmt;
PREPARE stmt FROM @delStmt;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET GROUP_CONCAT_MAX_LEN=10000;
SELECT concat("DROP TABLE ",GROUP_CONCAT(TABLE_NAME))
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'apctdmymsepem'
AND TABLE_NAME LIKE 'norma%';