存储过程 插入表数据 循环

1.存储过程 插入表数据 循环

create procedure u_head_and_low_pro()

BEGIN
	DECLARE i INT DEFAULT 0;
	WHILE i < 1000000
	DO
		INSERT INTO tb_test(userName,useStatus)VALUES (i,0);
		SET i = i + 1;
	END WHILE;
END

　　

 

BEGINDECLARE i INT DEFAULT 0;WHILE i < 1000000DOINSERT INTO tb_test(userName,useStatus)VALUES (i,0);SET i = i + 1;END WHILE;END