Mysql function variable

CREATE PROCEDURE p(increment INT)
BEGIN
  DECLARE counter INT DEFAULT 0;
  WHILE counter < 10 DO
    -- ... do work ...
    SET counter = counter + increment;
  END WHILE;
END;

Source: dev.mysql.com

Similar codes

52 votes609 views6 answers
Rename column sql
SQL
0 vote352 views1 answer
Mysql bind-address default value
SQL
-1 vote344 views1 answer
How to create foreign key in sql server management studio
SQL
5 votes357 views1 answer
Sort order on two columns sql
SQL
0 vote356 views4 answers
Mysql desactivar trigger
SQL
0 vote319 views1 answer
Deleted table in sql trigger
SQL
0 vote362 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote385 views1 answer
Table structure in sql
SQL
1 vote507 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
15 votes360 views5 answers
If null mysql
SQL