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
SELECT from SQL into variable General	6	2740	27 December 2019
Looking for help with referencing object values General	17	445	15 March 2021
Walkthrough for SQL queries to basic guages and multi series/line charting? Does it exist? General	7	574	2 October 2020
Problem getting data from mysql db to line chart General	6	302	4 October 2022
JSON Api weather data General	41	1157	17 February 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.

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

Related topics