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

5 votes112 views2 answers
Sql server port number
SQL
0 vote119 views2 answers
Sql day from datetime
SQL
-1 vote117 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote129 views1 answer
Mysql where sum > 0
SQL
1 vote111 views1 answer
Sql server reseed single table
SQL
0 vote111 views1 answer
On update current_timestamp jpa
SQL
0 vote109 views1 answer
Select all same column value in sql
SQL
0 vote123 views1 answer
Dump db only triggers mysql
SQL
0 vote123 views2 answers
Wordpress change url in database
SQL
0 vote135 views1 answer
Mysql delete entire row on condition
SQL