通过while语句实现循环插入数据
BEGIN
DECLARE a INT DEFAULT 1;
WHILE (a <= 1000) DO
INSERT INTO equipment_log (equipment_id, x_vibrate, y_vibrate, z_vibrate, front_bearing_temp, back_bearing_temp, power, flow, radial_signal, axial_signal, current, stator_cavity_pressure, winding_temp, turn, fwd, rev, u_ele, v_ele, w_ele, pick_time) VALUES (1, '测试1', '测试1', '测试1', rand_num(1, 9), rand_num(1, 9), rand_num(1, 9), rand_num(1, 9), rand_num(1, 900), rand_num(1, 1200), rand_num(1, 9), rand_num(1, 9), rand_num(1, 9), rand_num(1, 9), 0, 1, 0, 0, 0, SUBDATE(now(),interval 10*a minute));
SET a = a + 1;
END WHILE;
END
参考: https://blog.csdn.net/Bulter1996/article/details/91911136