#存储过程 postgresql
CREATE OR replace function
creatDate2() returns
bloolean AS
$BODY$
DECLARE ii INTEGER;
begin
ii:=1;
FOR ii IN 1000..2000 LOOP
insert into carousel (carousel_id,
img_path,
describes
)
VALUEs
(ii,'111',123456);
end loop;
RETURN true;
end;
$BODY$
LANGUAGE mysql;
#存储 mysql
delimiter $$
create procedure pre()
begin
declare i int;
set i=200;
while i<1000000 do
insert into carousel (carousel_id,
img_path,
describes
)
VALUEs
(i,'111',123456);
set i=i+1;
end while;
end
$$
#ִ执行
call pre();
sql存储过程(百万级别数据创建)
于 2022-11-12 02:08:43 首次发布