存储过程 for循环插入数据

存储过程 for循环插入数据

DELIMITER $$ 
CREATE PROCEDURE InsertDataChars1(IN v_count INT)
BEGIN
  DECLARE v_counter INT DEFAULT 1;
    DECLARE v_dt INT DEFAULT 1710345600;    
  WHILE v_counter <= v_count DO
        SET v_dt = v_dt + 60;    
        INSERT INTO monitor_data_chars (ts, temperature, sphygmus, blood_oxygen, urine_volume, patient_id, q_max, depart_id, sickbed_number )
        VALUES (FROM_UNIXTIME(v_dt), FLOOR(34 + (42-34)*RAND()), FLOOR(50 + (110-50)*RAND()), FLOOR(95 + (100-95)*RAND()), 200, 321, 0, 259, 2);        
    SET v_counter = v_counter + 1;
  END WHILE;
END$$ 
DELIMITER ;

CALL InsertDataChars1(1400);