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 {"…

Thanks, All fixed. I used your query example as well. Now just trying to learn how to do a query that returns all the temp data for 24 hours and put it on a chart.

Node-RED

Node-RED Forum

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

General

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	1342	23 December 2019
Node red to database General	2	365	23 April 2019
Get value from mysql in debug General database	8	270	5 December 2022
SELECT from SQL into variable General	6	2847	27 December 2019
Walkthrough for SQL queries to basic guages and multi series/line charting? Does it exist? General	7	642	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