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…

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	309	30 October 2022
Temp and Hum store in MySQL General	14	4197	14 February 2021
MySQL NODE-RED table General	33	11490	8 February 2019
Using mysql node but no joy with insert query General	7	1807	29 August 2020
Insert Into MySQL Database General	16	13390	3 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.

mySQL INSERT INTO with multiple msg.xxx failing

Related Topics