数据库插入大量数据的方法

知识永远学不完，但多懂一点知识就会让生活更轻松一点！

想要根据id或者代码按顺序插入大量数据，使用存储

注释：函数定义
DROP PROCEDURE IF EXISTS pro_copy
CREATE PROCEDURE pro_copy(in num BIGINT ,in count int )
BEGIN
DECLARE sce_code VARCHAR(60);
SET @i = num;
WHILE @i<=count DO

注释：需要单独设置的字段值
SET sce_code = CONCAT(@i,’.SH’);

INSERT INTO cp_quote_budget.meson_pretreatment (Gangtise_Code, Tradingday, ClosePrice, Close_3day, Close_5day, Close_10day, Close_20day, Close_60day, Close_120day, Close_250day, Close_750day, ClpLastYear, HighestPrice, LowestPrice, HighPrice52, LowPrice52, AvgVol5, MaxPctChg_N, MinPctChg_N, RiseDays, FallDays, type)
VALUES (sce_code, ‘2022-01-14 10:00:00’, ‘46.3500’, ‘54.4700’, ‘53.1600’, NULL, ‘53.8100’, ‘43.5900’, NULL, NULL, NULL, ‘56.8000’, ‘75.2000’, ‘42.7500’, ‘75.2000’, ‘42.7500’, ‘559698.2000’, NULL, NULL, NULL, NULL, NULL);

set @i = @i + 1;

END WHILE;
end;

循环初始值，次数

CALL pro_copy(1,1000)

数据库里直接执行
我的需求：从100000.SH-105500.SH插入数据

## 函数定义
DROP PROCEDURE IF EXISTS `pro_copy`
CREATE