# MySQL NODE-RED table

**URL:** https://discourse.nodered.org/t/mysql-node-red-table/7612
**Category:** General
**Created:** [5 February 2019 12:11 UTC](https://discourse.nodered.org/t/mysql-node-red-table/7612 "2019-02-05T12:11:46Z")
**Posts on this page:** 1
**Showing post:** 23

<div class="post-metadata">

### Author: ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)
#### Post date: [5 February 2019 18:08 UTC](https://discourse.nodered.org/t/mysql-node-red-table/7612/23 "2019-02-05T18:08:36Z")

</div>

Hi @smalhao

as you have changed the Join node to generate a key/value object, the `msg.payload[0]` way of accessing its properties is no longer the right way to do it.

This page in the docs explains how you can use the Debug sidebar to identify how to access different parts of a message: [https://nodered.org/docs/user-guide/messages](https://nodered.org/docs/user-guide/messages)

If you look at the Debug message, you can see `msg.payload` is no longer an array, but an Object. It has three properties:

```javascript
{
   "ns=2;s=LM35": 23.0550....,
   "ns=2;s=SensorIndutivo": 7514.689.....,
   "ns=2;s=LM335": 22.2104...
}

```

So you would access those properties as:

```javascript
msg.payload["ns=2;s=LM35"]
msg.payload["ns=2;s=SensorIndutivo"]
msg.payload["ns=2;s=LM335"] 

```

in your Function node, in place of `msg.payload[0]`, `msg.payload[1]` and `msg.payload[2]`.

---

_[View the full topic](https://discourse.nodered.org/t/mysql-node-red-table/7612)._