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

0 vote280 views1 answer
Commit transaction sql
SQL
7 votes268 views1 answer
Sql management studio display line numbers
SQL
1 vote293 views1 answer
Oracle previous year
SQL
10 votes289 views3 answers
Sql select between two dates
SQL
0 vote296 views1 answer
How to find symmetric pairs in sql
SQL
0 vote298 views1 answer
Oarcale list objects
SQL
1 vote305 views1 answer
Alter constraint in sql
SQL
25 votes281 views5 answers
Uninstall mysql ubuntu
SQL
0 vote295 views1 answer
Sql server user permissions and roles
SQL
1 vote292 views3 answers
What is union in sql
SQL