BEGIN
DECLARE
i int;
BEGIN
i := 1 ;
WHILE i < 5 loop
i := i + 1;
INSERT INTO “PUBLIC”.“TABLE”
(“ID”,“NAME”,“AGE”,“HANF” )
VALUES
(i,i+1,i+2,i+3 );
end loop;
END;
END;
人大金仓数据库V7批量添加数据库语句
最新推荐文章于 2024-05-17 13:20:02 发布
BEGIN
DECLARE
i int;
BEGIN
i := 1 ;
WHILE i < 5 loop
i := i + 1;
INSERT INTO “PUBLIC”.“TABLE”
(“ID”,“NAME”,“AGE”,“HANF” )
VALUES
(i,i+1,i+2,i+3 );
end loop;
END;
END;