Skip to content

Instantly share code, notes, and snippets.

@mikelemus27

mikelemus27/mysql-repeat-1,sql

Created July 10, 2020 05:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mikelemus27/67872b4ecd0ffe9313991f3190a14477 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mikelemus27/67872b4ecd0ffe9313991f3190a14477 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-repeat-1,sql
CREATE PROCEDURE dorepeat(p1 INT)
BEGIN
SET @x = 0;
REPEAT
SET @x = @x + 1;
UNTIL @x > p1 END REPEAT;
END
//
mysql> CALL dorepeat(1000)//
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment