# mySQL INSERT INTO with multiple msg.xxx failing

**URL:** https://discourse.nodered.org/t/mysql-insert-into-with-multiple-msg-xxx-failing/36169
**Category:** General
**Created:** [19 November 2020 01:05 UTC](https://discourse.nodered.org/t/mysql-insert-into-with-multiple-msg-xxx-failing/36169 "2020-11-19T01:05:54Z")
**Posts on this page:** 1
**Showing post:** 13

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 November 2020 17:48 UTC](https://discourse.nodered.org/t/mysql-insert-into-with-multiple-msg-xxx-failing/36169/13 "2020-11-28T17:48:27Z")

</div>

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](https://discourse.nodered.org/t/data-from-mysql-db-to-graph/36115/15):
>
> 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…

---

_[View the full topic](https://discourse.nodered.org/t/mysql-insert-into-with-multiple-msg-xxx-failing/36169)._