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

-1 vote181 views5 answers
Convert sql to linq query online
SQL
0 vote299 views2 answers
Execute stored procedure without db set
SQL
4 votes200 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote175 views1 answer
Ms sql filter all sympbol
SQL
5 votes169 views1 answer
Mysql add user with all privileges
SQL
0 vote162 views1 answer
Sql comparison operators
SQL
1 vote166 views1 answer
Partition by sql server
SQL
0 vote175 views1 answer
Nueva tabla mysql
SQL
0 vote162 views1 answer
Get number of rows in every table mysql
SQL
1 vote192 views1 answer
Postgresql not in
SQL