使用SQL脚本输出批量创建文件夹结构

-- 创建文件夹表
CREATE TABLE folders (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    parent_id INT
);

-- 插入根文件夹
INSERT INTO folders (id, name, parent_id)
VALUES (1, '根文件夹', NULL);

-- 插入子文件夹
INSERT INTO folders (id, name, parent_id)
VALUES (2, '子文件夹1', 1);

INSERT INTO folders (id, name, parent_id)
VALUES (3, '子文件夹2', 1);

-- 插入孙子文件夹
INSERT INTO folders (id, name, parent_id)
VALUES (4, '孙子文件夹1', 2);

INSERT INTO folders (id, name, parent_id)
VALUES (5, '孙子文件夹2', 2);

-- 查询文件夹结构
WITH RECURSIVE folder_tree AS (
    SELECT id, name, parent_id, 0 AS level
    FROM folders
    WHERE parent_id IS NULL
    UNION ALL
    SELECT f.id, f.name, f.parent_id, ft.level + 1
    FROM folders f
    JOIN folder_tree ft ON f.parent_id = ft.id
)
SELECT id, name, level
FROM folder_tree
ORDER BY id;