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 vote218 views1 answer
T-SQL - Where Used List (Table/View)
SQL
2 votes199 views4 answers
Mysql get all tables row count
SQL
11 votes194 views3 answers
Sqlite3 create table from another table
SQL
0 vote207 views1 answer
How to locate pg_hba.conf file
SQL
22 votes232 views3 answers
Sql cheat sheet
SQL
0 vote208 views1 answer
Oracle list subpartitions
SQL
0 vote225 views1 answer
Oracle enable chain
SQL
1 vote208 views1 answer
Sql how to replace full stop
SQL
1 vote191 views1 answer
Alter table column size oracle
SQL
9 votes184 views1 answer
Mysql check date range
SQL