Been working on this for several days and have exhausted my abilities and various suggestions via the web and these forums...so thank you in advance for any assistance! Basis: Have 3 MQTT inputs/message payloads In node red, converting payload to number(s) Since all messages had same designation …

This thread has veered off from "mySQL INSERT INTO with multiple msg.xxx failing" to "how to send mySQL data to a chart" It should really be a new thread (to attract the correct people)! Anyhow - the below thread is almost identical - it should give you a head start. [image] Data…

mySQL INSERT INTO with multiple msg.xxx failing

General

Paul-Reed 28 November 2020 21:32 15

New topic created at Dynamic series identification from message, send data to Chart

Topic		Replies	Views
Joining msg.payload and then sending to SQLite. Two entries instead of one General database , function-node , mqtt	3	313	30 October 2022
Temp and Hum store in MySQL General	14	4201	14 February 2021
MySQL NODE-RED table General	33	11502	8 February 2019
ISSUE with storing MQTT values to mySQL database : the values store as "undefined". Any guidence is much appreciated General database	10	783	13 May 2022
Using mysql node but no joy with insert query General	7	1821	29 August 2020

mySQL INSERT INTO with multiple msg.xxx failing

Related topics