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 vote382 views1 answer
The differnece between to values in sql
SQL
0 vote252 views1 answer
R write csv without index
SQL
1 vote198 views1 answer
Foreign key in oracle sql developer
SQL
1 vote251 views1 answer
Mysql workbench in ubuntu 14.04
SQL
4 votes278 views1 answer
Ms sql truncate table vs delete
SQL
0 vote234 views1 answer
Test connection to sql server
SQL
1 vote231 views2 answers
Oracle replace
SQL
0 vote243 views1 answer
Mysql default timestamp value to be current timestamp
SQL
14 votes228 views2 answers
How to auto increment in sql
SQL
0 vote238 views1 answer
Add sqlcmd to path linux
SQL