循环和在mysql中值插入表 [英] looping and inserting values into a table in mysql

问题描述

您好我有两个数组作为输入。我想插入使用循环表。
这是我都试过了。

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;

这是我写的程序只是一部分。当执行查询时出现错误出现了认为.p_privilege_fk（）函数不存在。
任何人都可以请帮助。

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.

推荐答案

尝试是这样的：

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

这篇关于循环和在mysql中值插入表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！