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

27 votes326 views6 answers
Set password mysql
SQL
12 votes315 views1 answer
Psql drop column
SQL
5 votes314 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote336 views2 answers
Pop sql insert value into
SQL
0 vote269 views1 answer
Expose db in virtualbox
SQL
3 votes322 views1 answer
Postgresql db owner change
SQL
9 votes339 views1 answer
Alter table column change data type to text mysql
SQL
12 votes346 views5 answers
Rename table in mysql
SQL
0 vote304 views1 answer
Uuid sqlalcomany
SQL
0 vote345 views2 answers
Oracle chain rules
SQL