CREATE PROCEDURE test() #创建存储函数;
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i < 5000 DO
#下面的insert语法要改成自己的表,同时构造value.id,要考虑防重;
INSERT INTO `wbms_1`.`waybill_weight_volume_2`(`id`, `tenant_id`, `waybill_code`, `operate_code`, `volume`, `weight`, `length`, `width`, `height`, `weight_time`, `volume_time`, `ope_type`, `operator_code`, `operator_name`, `operate_station_code`, `operate_station`, `is_delete`, `create_time`, `update_time`, `create_user`, `update_user`, `ts`) VALUES (1356063857646284800+i, 'test', 'ZY1000502218621', 'ZY1000502218621-1-2-', 55.0000, 55.0000, 5.5000, 55.0000, 55.0000, '2020-09-20 16:39:56', '2020-09-20 16:39:56', 3, '21180252', '陈青山', '308766', '南京江骏营业部', 0, '2021-02-01 10:16:32', '2021-02-01 10:16:32', NULL, NULL, '2021-02-01 10:16:32.000');
SET i = i+1;
end WHILE;
END;
CALL test();#调用存储函数
Mysql循环insert数据
同学们你们还有案例吗 ?