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

Topic		Replies	Views
Read from mysql db Dashboard	54	17687	23 December 2018
Building a dynamic msg.topic to create a mysql insert statement General	17	264	8 July 2025
MsgPayload into a query on nodered-sqlite General	2	3338	16 May 2018
Storing latest messages by topic for a possible request General	6	1114	8 May 2021
Code function to collect data from mqtt General database , function-node	4	1278	2 December 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.

Define a new message

Related topics