I am tried to read data from MySQL db from node red flow. I have created the flow below but it doesn't show me any an error or anything at all.any help regard this please? [flow] This my flow shown below [{"id":"a39c7184.d9df6","type":"mysql","z":"627ecc4d.710c94","mydb":"494c5b78.7c6a84","name…

As I said you should put the three backticks on separate lines before and after the flow, so the forum knows it is code. I am not sure exactly what you did but anyway I managed to import the flow. The message says you are return a string. You are returning msg.topic which is a string, so the mess…

@Tefita - in the join node, set the "Send the message -> After a number of message parts" to 2. As it is, you are only sending one value thru and it is in msg.payload. when you put in the 2 you should see th key:value pairs showing up. not msg.payload.temp_amp

Thank you for answering my questions, but I still have problems, do not know if I should change something in the node template? [image3] [image2]

Colin, place the node debug on all the nodes, and send no more information than the capture.

Please attach an export of your flow

Thanks for your help, here is the flow [{"id":"9f5049ab.a43a98","type":"mqtt in","z":"284cd45c.6a8e2c","name":"","topic":"prueba1/temp_amb","qos":"0","broker":"478ceb99.2c8d94","x":328,"y":306.9895658493042,"wires":[["4a052a03.7d37c4"]]},{"id":"80161886.658e18","type":"mqtt in","z":"284cd45c.6a8e2c…

Oh thanks the correction, I hope the flow is fine

In your template node you have INSERT INTO dispositivo2 (temp_amb, temp_corp) VALUES ({{payload.temp_amb}}, {{payload.temp_corp}}); so when and where are msg.payload.temp_amp and msg.payload.temp_corp being created? (HINT: You might want to change the debug node's so they display the complete msg …

I made the given suggestion and the changes were made, but then I must change the template node to another node, to get the insertion in the database Thanks for the help [f1] [f2]

You have the Join node set to Combine each msg.topic. It should be combine each msg.payload using topic as the key. Change that then look at the output of the join node again particularly what is in the payload to see what you have to put in the template.

Node-RED

Node-RED Forum

Read from mysql db

Dashboard

ukmoose 14 November 2018 15:56 30

please read this post and then edit your post above How to share code or flow json

Topic		Replies	Views
Input multiple sensor outputs into mysql General	13	1978	16 November 2020
Flow to insert into MySQL table General	6	2096	3 September 2020
How to insert in a database? General database	48	2476	19 October 2022
Format KNX values into SQL INSERT for MYSQL General	15	1614	14 May 2020
How to save a value from a node to database General home-assistant	14	314	2 June 2023

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.

Read from mysql db

Related topics