# Problem getting data from mysql db to line chart

**URL:** <https://discourse.nodered.org/t/problem-getting-data-from-mysql-db-to-line-chart/67973>\
**Category:** General\
**Created:** [20 September 2022 12:51 UTC](https://discourse.nodered.org/t/problem-getting-data-from-mysql-db-to-line-chart/67973 "2022-09-20T12:51:28Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [20 September 2022 13:01 UTC](https://discourse.nodered.org/t/problem-getting-data-from-mysql-db-to-line-chart/67973/2 "2022-09-20T13:01:08Z")

</div>

You could probably adapt this dynamic routine with little ease...

> [@Dynamic series identification from message, send data to Chart](https://discourse.nodered.org/t/dynamic-series-identification-from-message-send-data-to-chart/36682/5):
>
> So, i am not 100% certain what you are after but if (by the title "dynamic series") you mean sending alternative types of data from a database (i.e. varying fields and varying quantities) then this should get you close. It was a simple adaption of the previous solution I pointed you to, modified to build the series from the field names of the 1st data element in the data passed in. There are 2 injects to simulate two different sets of mySQL data [image] [{"id":"227e8b13.87c804…

---

_[View the full topic](https://discourse.nodered.org/t/problem-getting-data-from-mysql-db-to-line-chart/67973)._