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 vote297 views1 answer
Flexible search query delete table
SQL
0 vote283 views1 answer
List mysql tables and views
SQL
1 vote280 views3 answers
Mysql disable foreign keys check
SQL
0 vote278 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote461 views1 answer
Postgres upgrade to superuser
SQL
0 vote272 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote290 views1 answer
Drush run sql select
SQL
19 votes292 views5 answers
Mysql between date range
SQL
0 vote306 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote301 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL