mysql插入自定义数据和删除id范围
xuexi 2026-01-19 16:14:50 发表在:PHP 查看数:61
 INSERT INTO cb_shebei_datadisk (bs, create_time)
SELECT
    '17688993169698',  -- 固定为该数字,不再拼接n
    NOW()              -- 创建时间为当前时间
FROM (
    -- 递归CTE生成数字序列,控制插入的条数
    WITH RECURSIVE num_seq (n) AS (
        SELECT 1        -- 初始值
        UNION ALL
        SELECT n + 1 FROM num_seq WHERE n < 6  -- 终止条件:生成1-5,共5条数据
    )
    SELECT n FROM num_seq
) AS t;

DELETE FROM cb_shebei 
###删除id范围1到838
WHERE id BETWEEN 1 AND 838;
最近访问时间:2026-01-24 22:52:07
知识库:414条鸣谢:TAY  备案号:蜀ICP备2024090044号-1