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] [image] msg.topic = "INSERT INTO realtimealtprg01 (Speed, ProductName, TensionUW, TensionIF, TensionOf, TensionRW, UW, RW, ProductA, Produ…

[image] Sobri: why the results in the MySQL database are all 0 for all columns 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 loo…

Topic		Replies	Views
Could not save PLC output data from mqtt node to MySQL Industrial	13	332	1 April 2024
Error was reported when the data is stored in the Mysql General	1	441	1 December 2019
Error when entering data in Mysql General	5	928	21 February 2022
Trouble entering data to mysql General	10	2057	15 May 2020
MySQL Data Logging Issue General	26	1103	11 March 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Results in the MySQL database are all 0 for all columns

Related topics