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

2 votes363 views3 answers
Sql function
SQL
0 vote332 views1 answer
Select odd records sql
SQL
19 votes377 views5 answers
Display table in sql
SQL
1 vote332 views1 answer
Postgresql transaction discard all
SQL
21 votes376 views6 answers
Update sql
SQL
50 votes417 views6 answers
Install mysql on ubuntu
SQL
0 vote375 views1 answer
Sql out file formate
SQL
0 vote316 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote382 views1 answer
Combine 2 columns search query mysql
SQL
0 vote371 views1 answer
Get statis values sql
SQL