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

7 votes191 views2 answers
Execute mysql file
SQL
1 vote191 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote177 views1 answer
Mysql server not starting in xampp in mac
SQL
1 vote185 views1 answer
How to select random rows from table
SQL
0 vote213 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote188 views1 answer
Acual month sql
SQL
0 vote166 views1 answer
Hangfire clean script
SQL
0 vote186 views1 answer
Authentication in sql server
SQL
0 vote237 views1 answer
Oracle show running job
SQL
0 vote186 views1 answer
Pgsql is not permitted to log in
SQL