need help with mysql

[Touti]

Code Select Expand


declare @x int;
set @x = 1;
while @x < 8
begin
    Do whatever you need to do.
    Set @x = @x + 1
End


Anyone knows how to make this work in mysql ?  It seems that you can't declare variables outside of BEGIN...END structures.  How stupid is that ?