删除mysql数据库内所有表

-- 列出所有表
SHOW TABLES;

-- 逐个删除表
DROP TABLE table_name;

-- 创建一个存储过程来删除所有表
DELIMITER $$
CREATE PROCEDURE `drop_all_tables`()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE tableName VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_schema = 'your_database_name';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO tableName;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @drop_sql = CONCAT('DROP TABLE ', tableName);
        PREPARE stmt FROM @drop_sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE cur;
END$$
DELIMITER ;

-- 调用存储过程
CALL drop_all_tables();