Mysql procedure loop with step

Question

Mysql procedure loop with step

Please be aware that I am learning MySQL as my application continues to grow. Please keep this in mind if you are kind enough to answer my question.

I am trying to achieve the following

I added a new row to the table, keeping track of the game number in the round, this way it will have values 1,2,3,4 .... when the round ends it will be reset to 1, etc.

I read in the MySQL manual about loops and came up with this, however it says my syntax is wrong, I would appreciate it if a more experienced user could consider this for me.

CREATE PROCEDURE inc()
    BEGIN
      DECLARE v1 INT 

      WHILE `round` ='1'

        SET v1 = v1 + 1;
    update events set `round_game_nr` ='v1'
      END WHILE;
    END;

I am trying to achieve this

enter image description here

, where the 1st column is round, and the second column is nr games

+3

sql mysql

Timothy coetzee May 18 '15 @ 7:18 am

source to share

1 answer

Yu Yenkan · Answer 1 · 2015-05-18T07:28:07+0000

CREATE PROCEDURE inc()
BEGIN
  DECLARE v1 INT;    --semicolon missing

  WHILE `round` ='1' DO    --Do missing

    SET v1 = v1 + 1;
update events set `round_game_nr` =v1;   --semicolon missing, v1 should not with ``
  END WHILE;
END;

Mysql procedure loop with step

More articles: