Noob here just learning about Node-Red. I have a mysql table with a heap of weather data from my home weather station controlled by a Wemos D1. Its working fine and sending weather data to the Mqqt / Red-node via a JSON string every 30 seconds or so. I have Red-Node then extracting that JSON strin…

Hello @richard.vince and welcome to the forum. I presume that you are using the most common MySQL node, node-red-node-mysql? The node returns an array of objects ("object" is more or less synonymous with JSON string). In your example the array only has one element msg.payload[0] which contains {"…

jbudd 25 March 2024 09:26 4

You might find this thread helpful, though it relates to SQLite not MySQL

Topic		Replies	Views
Node-red and mySQL show different output General	8	1307	23 December 2019
Node red to database General	2	352	23 April 2019
Get value from mysql in debug General database	8	240	5 December 2022
SELECT from SQL into variable General	6	2783	27 December 2019
Walkthrough for SQL queries to basic guages and multi series/line charting? Does it exist? General	7	605	2 October 2020

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.

SQL Select statement returning object name in the result with Node-Red

Related topics