mySQL INSERT INTO with multiple msg.xxx failing

[Steve-Mcl]

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.

Data from MySQL db to Graph

OK, I'm back. Its the parsing, like i said I only had 5 minutes to knock that demo up (but no time to test it) So another 5 mins & its now pushing the data into the chart data in the correct format. Try this instead... [{"id":"d3d38637.1f7408","type":"inject","z":"a9fbaedc.8f9c1","name":"Fake DB data","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"timeNRchar\":\"2020-11-18 18:25:48.906\",\"temp\":21.3,\"humi…