MySQL Loop Variable in a Query
loops, mysql, sql
Solution
DOne :)
I have just created variable i as @i and it is all solved.
Like this:
set @i=0;
while @i<25 do
insert into a (x,y,z)
select a,b,@i
from table1;
set @i= @i+1;
end while;
thx anyway :)
Problem
I want to use the loop index "i" in the result of my select statement in order to insert it into another table. Is is like: ``` set i=0; while i<25 do insert into a (x,y,z) select a,b,i from table1; set i= i+1; end while; ``` What is the way to do it?