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 vote146 views1 answer
Mysql change root mysql_native_password
SQL
10 votes262 views4 answers
Mysql if else
SQL
0 vote136 views1 answer
Coalesce for comma separated in sql server
SQL
3 votes146 views1 answer
Oracle apex call duration
SQL
25 votes175 views5 answers
Mysql replace text
SQL
2 votes144 views2 answers
Storing timezones in postgres
SQL
0 vote159 views1 answer
Postgres full text search example
SQL
0 vote97 views2 answers
Sql query unique
SQL
0 vote143 views1 answer
Sql server query database space available
SQL
9 votes161 views1 answer
Alter table column change data type to text mysql
SQL