mysql插入自定义数据和删除id范围
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