存储过程 插入表数据 循环

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

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