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 vote107 views1 answer
Sql server delete records with specific date
SQL
0 vote125 views1 answer
Mysql preg replace
SQL
4 votes100 views1 answer
Find tables with column name in sql
SQL
0 vote119 views1 answer
Default column value in sql same as another column laravel
SQL
1 vote121 views1 answer
UseSqlServer no definition
SQL
1 vote104 views1 answer
Mysql select row max date
SQL
0 vote102 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote102 views1 answer
Search from comma separated values in sql server
SQL
0 vote116 views1 answer
Mysql equivalent decode oracle
SQL
0 vote111 views1 answer
Convert multiple columns to ROws in sql server
SQL