postgre循环插入表数据
do $$
declare
v_idx integer := 1;
begin
while v_idx < 96 loop
INSERT INTO table(col1,col2) values (v_idx, 123);
v_idx = v_idx + 1;
end loop;
end $$;
Java/Python/Go,软件测试等等
do $$
declare
v_idx integer := 1;
begin
while v_idx < 96 loop
INSERT INTO table(col1,col2) values (v_idx, 123);
v_idx = v_idx + 1;
end loop;
end $$;