MySQL Stored procedure Learning

One: MySQL creates a stored procedure that modifies a table field

drop procedure if exists pr_test;

CREATE PROCEDURE Pr_test ()

Begin
declare var int; declare var1 int;
Set var=416; Set var1=420;
While var<850001 do
Update xxx Set bb= ' 217 ', aa= ' 237 ' where ID between Var and var1;
Set var=var+10;
Set var1=var1+10;
End while;
End

Two: Calling a stored procedure

Call Pr_test ();

Three: note the

1) at the end of each statement in the MySQL stored procedure, add a semicolon ";"

2) If the MySQL stored procedure contains multiple MySQL statements, the BEGIN END keyword is required

3) mysql stored procedure is required, even if there is no parameter, "()"