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

4 votes135 views3 answers
Copy table postgres
SQL
-1 vote153 views1 answer
Export mysql table to file
SQL
0 vote135 views2 answers
Add new column after in sql
SQL
0 vote141 views1 answer
Psql attribute cannot login
SQL
48 votes243 views3 answers
Psql create database
SQL
0 vote144 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote163 views1 answer
Sql statement show all emails with dome
SQL
1 vote147 views1 answer
Mysql text to decimal
SQL
0 vote168 views1 answer
Find how many tables in database sql query
SQL
1 vote149 views1 answer
Mysql drop key
SQL