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

1 vote228 views1 answer
Oracle truncate partition
SQL
2 votes233 views2 answers
Mysql count rows returned
SQL
3 votes192 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote204 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
6 votes212 views2 answers
Mysql set primary key
SQL
1 vote207 views1 answer
Nested if in mysql
SQL
1 vote220 views1 answer
Events mysql
SQL
0 vote219 views1 answer
Possgress drop if exists view
SQL
0 vote245 views1 answer
Oracle plsql sleep
SQL
0 vote234 views1 answer
Mysql 5.7 in centos 7
SQL