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

22 votes181 views3 answers
Year format in date mysql
SQL
1 vote164 views1 answer
What is intersect
SQL
0 vote203 views3 answers
Mysql keyword search
SQL
0 vote209 views1 answer
Drop domain postgresql
SQL
9 votes182 views6 answers
Sql add column with default value
SQL
0 vote174 views1 answer
Providername system.data. mysql
SQL
2 votes222 views1 answer
Merge two columns in sql oracle
SQL
0 vote168 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote168 views1 answer
Mysql where in keep order
SQL
0 vote187 views1 answer
Sql query wordpress export post
SQL