looping and inserting values into a table in mysql

Question

Hi I have two arrays as input. I want to insert into a table using loop. This is what I have tried.

simple_loop:LOOP

SET i = i + 1;
     simples_loop:LOOP
     SET j = j + 1;
     INSERT INTO ROLE_PRIVILEGE_BRIDGE (ROLE_ID,PRIVILEGE_ID,VALUE)
        VALUES(V_ROLE_FK,p_privilege_fk(i),p_values(j));
     END LOOP simples_loop;
END LOOP simple_loop;

This is just the portion of the procedure I have written. When executed the query an error showed up saying that ".p_privilege_fk() function does not exist.". Can anyone please help.

Sam · Accepted Answer · 2013-12-04 22:22:21Z

3

Try something like this:

INSERT INTO ROLE_PRIVILEGE_BRIDGE (ROLE_ID,PRIVILEGE_ID,VALUE) 
    (SELECT V_ROLE_FK, p_privilege_fk, p_privilege_fk FROM firstTable)

edited Dec 4, 2013 at 22:22

answered Nov 27, 2013 at 2:49

Sam

2,7613 gold badges22 silver badges31 bronze badges

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

1 Comment

Tin Tran Over a year ago

INSERT INTO ROLE_PRIVILEGE_BRIDGE (ROLE_ID,PRIVILEGE_ID,VALUE) SELECT V_ROLE_FK, p_privilege_fk, p_privilege_fk FROM firstTable

Collectives™ on Stack Overflow

looping and inserting values into a table in mysql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related