Results in the MySQL database are all 0 for all columns

General
1

why the results in the MySQL database are all 0 for all columns, can anyone tell me the correct code? The following flow and programming that I made

image
image1047×618 71.7 KB

image
image1366×768 153 KB

msg.topic = "INSERT INTO realtimealtprg01 (Speed, ProductName, TensionUW, TensionIF, TensionOf, TensionRW, UW, RW, ProductA, ProductB, ProductTotal ) VALUES ('', '','', '', '', '', '', '', '', '', '');"
return msg;
2

Please do not duplicate post, it confuses responses. You have responses here Could not save PLC output data from mqtt node to MySQL

3

Because that is what you have told it to do. I would suggest you add a debug node (set to display the complete msg object) to the output of the function node just before your mysql node and run your code.

Then look at the output of the debug node and read the 'Help' information of the mysql node to see what you have done.

With one line of code and two images, that is the best I can do to help you at this point.

[This topic has been closed since it is a duplicate]