Drop all tables in mysql database

drop_all_tables.sql

SET @tables = NULL;
SET GROUP_CONCAT_MAX_LEN=1048576;

SELECT GROUP_CONCAT('`', table_schema, '`.`', table_name, '`' SEPARATOR ',') INTO @tables
FROM   information_schema.tables
WHERE  table_schema = (SELECT DATABASE());

SELECT     IF(@tables IS NULL, 
              'SELECT NULL FROM (SELECT NULL) AS `empty` WHERE 0=1', 
              CONCAT('DROP TABLE IF EXISTS ', @tables)) INTO @tables;
PREPARE    dropTablesStmt FROM @tables;

SELECT     @@FOREIGN_KEY_CHECKS INTO @SAVED_FOREIGN_KEY_CHECKS;
SET        FOREIGN_KEY_CHECKS = 0;

EXECUTE    dropTablesStmt;

SET        FOREIGN_KEY_CHECKS = @SAVED_FOREIGN_KEY_CHECKS;

DEALLOCATE PREPARE dropTablesStmt;