postgresql、mysql循环插入

postgresqlDO $$ DECLAREv_idx INTEGER := 1;BEGINwhilev_idx <= 1000000loopv_idx = v_idx + 1;INSERT INTO "public"."ss" ( "a", "b", "c" )VALUES( 12341234, 12341234, 12341234 );END loop;END $$;mysqldrop

eryou_979

462人浏览 · 2021-07-20 13:44:07

eryou_979 · 2021-07-20 13:44:07 发布

postgresql

DO $$ DECLARE
v_idx INTEGER := 1;
BEGIN
		while
		v_idx <= 1000000
		loop
		v_idx = v_idx + 1;
	INSERT INTO "public"."ss" ( "a", "b", "c" )
	VALUES
		( 12341234, 12341234, 12341234 );
	
END loop;

END $$;

mysql

drop procedure IF EXISTS looptest;
delimiter $$$
create procedure looptest()
begin
declare i int default 0;
set i=0;
start transaction;
while i<=4000000 do
 INSERT INTO `test`.`ss` (`a`, `b`, `c`) VALUES (12345, 12345, 12345);
set i=i+1;
end while;
commit;
end
$$$
delimiter;

call looptest();