# Mysql data logging

**URL:** <https://discourse.nodered.org/t/mysql-data-logging/78366>\
**Category:** General\
**Tags:** function-node\
**Created:** [11 May 2023 18:08 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366 "2023-05-11T18:08:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![PRABHAKAR82](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Post date:** [11 May 2023 18:08 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366/1 "2023-05-11T18:08:39Z")

</div>

I have to log 5 data together in different column,  
I write this query but it give "ER\_PARSE\_ERROR" please help.

var co = { payload: msg.payload[0]};

var ox = { payload: msg.payload[1]};

var lux = { payload: msg.payload[3]};

var temp = { payload: msg.payload[2]};

msg.topic = 'INSERT INTO`node-red`.`final`(`CO`,`OX`,`Lux`,`Temp`) VALUES (' + co + ',' + ox + ',' + lux + ',' + temp + ')';  
return msg;

I get data in this form whic i have to log in to my sql.

array[5]  
0: "4"  
1: "000"  
2: "000"  
3: "0032"  
4: "00"

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [11 May 2023 18:21 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366/2 "2023-05-11T18:21:35Z")

</div>

If you are using node-red-node-mysql, have you looked at the documentation for that node?

> **[node-red-node-mysql](https://flows.nodered.org/node/node-red-node-mysql)**
>
> A Node-RED node to read and write to a MySQL database

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [11 May 2023 18:34 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366/3 "2023-05-11T18:34:25Z")

</div>

> [@PRABHAKAR82](#):
>
> var co = { payload: msg.payload[0]};

If your payload is an array, then the first 4 lines should be

```auto
let co = msg.payload[0];

```

Same for ox, lux and temp

Also are these enter into Db as strings? If so they need to be quoted in the sql statement, or converted to numbers if numeric.

---

<div class="post-metadata">

**Author:** ![PRABHAKAR82](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Post date:** [11 May 2023 18:40 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366/4 "2023-05-11T18:40:53Z")

</div>

Thanks again E1cid.now its working.

---

<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:** [25 May 2023 18:41 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366/5 "2023-05-25T18:41:48Z")

</div>

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