How define a new topic in a function and use the result of this topic.

Clearly you have to pass the message above to the mysql node. The output of your query [Untitled 1] will be in the msg.payload returned from the mysql node. So you need a flow like this [Untitled 2] If this is not the solution you are looking for, supply the information people have asked for. …

Node-RED

Node-RED Forum

Define a new message

General

system Closed 10 August 2022 09:35 23

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

Topic		Replies	Views
Read from mysql db Dashboard	54	17579	23 December 2018
Building a dynamic msg.topic to create a mysql insert statement General	18	192	6 October 2025
MsgPayload into a query on nodered-sqlite General	2	3327	16 May 2018
Storing latest messages by topic for a possible request General	7	1081	22 May 2021
Code function to collect data from mqtt General database , function-node	5	1261	31 January 2022

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.

Define a new message

Related topics