mysql存储过程批量插入数据
DELIMITER //
CREATE PROCEDURE batch_insert(IN uid VARCHAR(100))
BEGIN
DECLARE i INT DEFAULT 1; – 初始化计数器变量为1
DECLARE d VARCHAR(10);
WHILE i <= 1000 DO – 设置要插入的记录条数(这里设定为10)
INSERT INTO work_time (uid, job_id,company_id,work_time,data_time,count_work_time_id,sg_app_id)
VALUES (uid,‘9f38c412-6220-4173-8460-463ad0499bf0’,‘7f4b30c2-8d52-4e4c-a383- f63ff53f8358’,i,d,i,‘688151a9-1419-49fd-9ac7-778ffca08c3a’); – 根据需求修改表名、列名和值
SET i = i + 1; -- 逐次自增计数器变量
-- 更新当前日期为下一天
SET d = CURDATE() + INTERVAL i DAY;
END WHILE;
END//
DELIMITER ;