mysql loop with variable incrementing

Question

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

it will be pretty simple to code this with php or similar just doing

$x=1++
while(round == 1){
INSERT INTO events (game_nr) values ('$x')
$x++
}

Is there something similar I can use as the above code on a mysql db using only mysql?

may be you are searching for "procedures" in mysql.

stacky
– stacky

2015-05-18 06:07:04 +00:00
Commented May 18, 2015 at 6:07 — stacky
– stacky, Commented May 18, 2015 at 6:07

Saty · Accepted Answer · 2015-05-18 06:09:51Z

3

Read manual Defined Variables in mysql

SET @x := 1; -- Define a variable
INSERT INTO events (game_nr) values (@x := @x + 1)

answered May 18, 2015 at 6:09

Saty

22.5k7 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

pala_ Over a year ago

beware this may not give you what you want if you expect some sort of ordering to the numbers

Tim C Over a year ago

Thanks!! Should I put a WHERE clause here aswell like SET @x := 1; -- Define a variable INSERT INTO events (game_nr) values (@x := @x + 1) WHERE round='1'

Collectives™ on Stack Overflow

mysql loop with variable incrementing

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related