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 vote186 views1 answer
Postgres delete where id in
SQL
12 votes207 views4 answers
SQL Where
SQL
0 vote238 views1 answer
Str_to_date sql server
SQL
0 vote179 views2 answers
Denormalization in sql
SQL
0 vote250 views1 answer
For row in sql database python loop
SQL
15 votes218 views2 answers
Sql order by multiple columns
SQL
1 vote221 views1 answer
Oracle add proxy
SQL
3 votes260 views6 answers
DB::table('users')->get();
SQL
0 vote230 views1 answer
Mysql grant access to one database
SQL
6 votes229 views1 answer
Postgresql add enum value
SQL