作者:jianyue1980_852 | 来源:互联网 | 2023-09-12 00:06
Iwanttodothequerybelowintoafunction:insertintotablevalues(msg.payload.1,msg.payload.2
I want to do the query below into a function: insert into table values (msg.payload.1, msg.payload.2);
我想在下面的查询中执行一个函数:insert into table values(msg.payload.1,msg.payload.2);
this function has two input (2 different msg.payload) so the code that I am trying to write is:
这个函数有两个输入(2个不同的msg.payload),所以我想写的代码是:
var m={
topic: "insert into info values ('"+msg.payload+"','"+msg.payload+"');"
};
return m;
it is adding two rows in the info table. but want to add only one row with two different values.
它在info表中添加了两行。但是只想添加一行有两个不同的值。
any idea?
Thanks in advance
提前致谢
1 个解决方案