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

49 votes398 views6 answers
Alter table add column
SQL
0 vote349 views1 answer
Sql describe
SQL
0 vote362 views1 answer
Display all node label neo4j
SQL
0 vote494 views1 answer
Sql insert exemplo
SQL
7 votes392 views1 answer
Oracle pagination query rownum
SQL
3 votes358 views1 answer
Async await mysql nodejs
SQL
0 vote344 views1 answer
Mysql database hyphen
SQL
0 vote330 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote351 views1 answer
Mysql how to truncate table with foreign keys
SQL
13 votes362 views2 answers
Sql join 3 tables
SQL