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 vote131 views2 answers
Many to many flask-sqlalchemy
SQL
2 votes138 views1 answer
Compare date in sql
SQL
3 votes132 views1 answer
Sql multiple column index
SQL
0 vote140 views1 answer
Power bi union columns
SQL
14 votes141 views2 answers
Oracle add attribute to table
SQL
20 votes131 views5 answers
Sql show tables
SQL
0 vote128 views1 answer
Sql check for null and empty string
SQL
5 votes131 views2 answers
Postgre insert select
SQL
2 votes146 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote161 views1 answer
This week mysql
SQL