# Organize values in SQL

**URL:** https://discourse.nodered.org/t/organize-values-in-sql/71006
**Category:** General
**Tags:** database
**Created:** [21 November 2022 18:14 UTC](https://discourse.nodered.org/t/organize-values-in-sql/71006 "2022-11-21T18:14:54Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Kefren\_lml](https://avatars.discourse-cdn.com/v4/letter/k/b782af/32.png) [@Kefren\_lml](https://discourse.nodered.org/u/Kefren_lml)
#### Post date: [21 November 2022 18:14 UTC](https://discourse.nodered.org/t/organize-values-in-sql/71006/1 "2022-11-21T18:14:54Z")

</div>

Hello

{"payload":{"TT1914.Val":33.463035583496094,"TT25011.Val":27.10765266418457,"FT\_Torre":-996},"\_msgid":"da09e59a60c864b6"}

The line before is the msg topic and payload i got from a eth node and need to add the 3 values into a table in sql one value for each column, I have the sql node already configured but do not know how to insert the values in separated columns.

Could you please help me?

Regards

Kefre

---

<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: [21 November 2022 20:30 UTC](https://discourse.nodered.org/t/organize-values-in-sql/71006/2 "2022-11-21T20:30:39Z")

</div>

We will need a lot more info to help you.

What does the SQL node built in help say?

Does the SQL node have demo flows in its readme?

Maybe it has built in example flows in `CTRL-I` → Examples → SQL Node?

* * *

Ok, more importantly...

- What version of Node-RED and NodeJS are you running?
- Is it installed on docker/home assistant or regular install?
- What SQL node are you actually using `node-red-contrib-xxxxx`?
- What have you tried so far & where are you stuck?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [20 January 2023 20:31 UTC](https://discourse.nodered.org/t/organize-values-in-sql/71006/3 "2023-01-20T20:31:13Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
