Sir my main motive is that real time sensor data stored in MySQL data base but i am phasing a problem that is 10/3/2019, 12:40:25 PM node: 6202ac64.340544 INSERT INTO iaqm_ceeri (Tem,Hum,Hi,Co,Co2,Aqi) VALUES ('undefined','undefined','undefined','undefined','undefined','undefined') : msg.payload : Ok…

What is the message that you are sending to the SQL node? Please make sure you show the msg.topic and the Path to the data you want to insert

Sending a sensor data. This is my flow chart please see and give me a solution. [{"id":"773ab736.c0b3a8","type":"tab","label":"Flow 4","disabled":false,"info":""},{"id":"5af16165.f7278","type":"mqtt in","z":"773ab736.c0b3a8","name":"","topic":"INDIA/CSIR/CEERI/Sensor","qos":"2","datatype":"auto","…

read this post but i dont got an answer

That post explains what you must do to format your flow in this forum so that someone else can import it. Without you doing that we cannot use your flow. You have also ignored my post where I ask for the message (ie data)

Node-RED

Node-RED Forum

Data Stored in MySQL

General

bakman2 3 October 2019 09:02 4

Please export your flow again, read this post and edit your post.

Topic		Replies	Views
Error was reported when the data is stored in the Mysql General	1	442	1 December 2019
Send dynamic topic mqtt data to mysql General mqtt	2	206	5 February 2023
Save MQTT data to MySQL General	8	5382	24 March 2020
MQTT input to MySQL General	4	887	20 September 2020
Temp and Hum store in MySQL General	13	4304	14 February 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.

Data Stored in MySQL

Related topics