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

14 votes100 views2 answers
Oracle add column with default value
SQL
10 votes191 views4 answers
Mysql if else
SQL
4 votes125 views1 answer
Ms sql truncate table vs delete
SQL
1 vote104 views1 answer
Postgres convert exisiting column to text
SQL
20 votes105 views6 answers
Change password in mysql
SQL
0 vote116 views1 answer
Postgres grep entire database
SQL
1 vote119 views1 answer
Spark sql convert string to date
SQL
0 vote144 views1 answer
Postgres extract number from string
SQL
1 vote96 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote151 views1 answer
<sql:datasource var="Snapsho"
SQL