use `dbName`; --your db name here | |
SET FOREIGN_KEY_CHECKS = 0; | |
SET @tables = NULL; | |
SET GROUP_CONCAT_MAX_LEN=32768; | |
SELECT GROUP_CONCAT('`', table_schema, '`.`', table_name, '`') INTO @tables | |
FROM information_schema.tables | |
WHERE table_schema = (SELECT DATABASE()); | |
SELECT IFNULL(@tables, '') INTO @tables; | |
SET @tables = CONCAT('DROP TABLE IF EXISTS ', @tables); | |
PREPARE stmt FROM @tables; | |
EXECUTE stmt; | |
DEALLOCATE PREPARE stmt; | |
SET FOREIGN_KEY_CHECKS = 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment