Mysql query set correct table name without ''

General
1

I want update mysql table
Inside function:

msg.payload = ['harm', 'day', 'val', 1];
msg.topic="UPDATE ? SET day=?,val=? WHERE id=?" ;
return msg;

How to put string 'harm' like harm not 'harm' because it cause problem.

2

I this what you need ? ''UPDATE dbname SET day= harm,val= day WHERE id=1"

[{"id":"1f9de5c0.4c944a","type":"tab","label":"Flow 11","disabled":false,"info":""},{"id":"375e9797.eb03b8","type":"inject","z":"1f9de5c0.4c944a","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[\"harm\",\"day\",\"val\",1]","payloadType":"json","x":300,"y":180,"wires":[["ee484d8d.280f4","4765b696.56d1f8"]]},{"id":"ee484d8d.280f4","type":"function","z":"1f9de5c0.4c944a","name":"","func":"\nmsg.topic=\"UPDATE \" + msg.payload[0] + \" SET day= '\" + msg.payload[1] + \"',val= '\" + msg.payload[2] + \"' WHERE id=\" + msg.payload[3] + \";\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":520,"y":240,"wires":[["30657752.7f00a8"]]},{"id":"30657752.7f00a8","type":"debug","z":"1f9de5c0.4c944a","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":690,"y":240,"wires":[]},{"id":"4765b696.56d1f8","type":"debug","z":"1f9de5c0.4c944a","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":550,"y":180,"wires":[]}]
3

I think my answer is probably identical to ScheepersJohan's.
But UPDATE 'harm' ... should be OK. What error do you see?

[{"id":"c570f516.3cc1f","type":"function","z":"e97a564a.ba7478","name":"","func":"msg.topic=\"UPDATE \" \n+ msg.payload[0] \n+ \" SET day = '\" + msg.payload[1] +\"'\"\n+ \", val = '\" + msg.payload[2] +\"'\"\n+ \" WHERE id= '\" + msg.payload[3] +\"'\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":270,"y":160,"wires":[["c0ea3774.fefef"]]},{"id":"c0ea3774.fefef","type":"debug","z":"e97a564a.ba7478","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"topic","targetType":"msg","statusVal":"","statusType":"auto","x":440,"y":160,"wires":[]},{"id":"a24d5f2c.a7e96","type":"inject","z":"e97a564a.ba7478","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[\"harm\", \"thursday\", \"next\", 1]","payloadType":"json","x":110,"y":160,"wires":[["c570f516.3cc1f"]]}]
4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.