# Format KNX values into SQL INSERT for MYSQL

**URL:** <https://discourse.nodered.org/t/format-knx-values-into-sql-insert-for-mysql/25774>\
**Category:** General\
**Created:** [29 April 2020 22:16 UTC](https://discourse.nodered.org/t/format-knx-values-into-sql-insert-for-mysql/25774 "2020-04-29T22:16:30Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [30 April 2020 10:09 UTC](https://discourse.nodered.org/t/format-knx-values-into-sql-insert-for-mysql/25774/4 "2020-04-30T10:09:27Z")

</div>

Hello again.

A Few things...

1. read [how to share code or flow json](https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506)
2. Put DEBUG nodes after every NODE to see what happens to the `msg` as it travels down the wire.
3. It is impossible to tell as you have only sent a screen shot.
  - We cannot see inside a function node from a screen shot

4. Have you read the BUILT IN HELP INFO in the sidebar of the MYSQL node? It tells you how to send SQL to the node.

Lastly, I strongly recommend you spend 20 minutes on this page - [working with messages](https://nodered.org/docs/user-guide/messages) - there is INVALUABLE information that will help you help yourself. Especially the bit about **"When you hover over any element, a set of buttons appear on the right"**

---

_[View the full topic](https://discourse.nodered.org/t/format-knx-values-into-sql-insert-for-mysql/25774)._