CODEWITHSUNDEEP
mysqlsqlloops
Neron
Neron

Reputation: 1578

MySQL Loop Variable in a Query

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?

Upvotes: 6

Views: 29026

Answers (2)

Neron
Neron

Reputation: 1578

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 :)

Upvotes: 2

tgkprog
tgkprog

Reputation: 4598

Open the table separately asa cursor, put fields in to variables, then use those variables and i to insert data in to the table with a 

insert into a (x,y,z) values (var1, var2, i).

What you have written would put multiple rows in to a table a with each value of i.

Upvotes: 0

Related Questions