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

0 vote370 views1 answer
Select insert new table sql server
SQL
0 vote369 views1 answer
On sql table data exists
SQL
0 vote362 views1 answer
Initcap in sql
SQL
2 votes369 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
2 votes421 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
1 vote379 views1 answer
Group_concat order by
SQL
3 votes384 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote388 views1 answer
Sql update subtract value
SQL
4 votes392 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote357 views1 answer
Mysql cdn link
SQL