# Mysql table UI layer show?

**URL:** <https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401>\
**Category:** General\
**Created:** [19 October 2021 08:49 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401 "2021-10-19T08:49:13Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![byramozgn](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@byramozgn](https://discourse.nodered.org/u/byramozgn)\
**Post date:** [19 October 2021 08:49 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/1 "2021-10-19T08:49:13Z")

</div>

Hello,  
I transfer the data from the sensor to the table in mysql.

How can I view the table in mysql in node-red UI layer?

 ![1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/b/bb38c3b5b777e9c1db0b34f831ff921c15d34e4a.png)  
 ![2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/7/076e67d94d6d471fdc5b5dd67c39b5c19e79494c.png)

---

<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:** [19 October 2021 09:08 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/2 "2021-10-19T09:08:04Z")

</div>

> [@byramozgn](#):
>
> How can I view the table in mysql in node-red UI layer?

Send a 'select' to the mysql node and then extract the data you want from the results and send the data to the UI node (formatted in the way the UI node wants)

---

<div class="post-metadata">

**Author:** ![byramozgn](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@byramozgn](https://discourse.nodered.org/u/byramozgn)\
**Post date:** [19 October 2021 09:20 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/3 "2021-10-19T09:20:30Z")

</div>

Which element will I use in the UI layer?

---

<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:** [19 October 2021 09:34 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/4 "2021-10-19T09:34:34Z")

</div>

Well that depends on what you want to display so I can't answer that question for you.

I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.

---

<div class="post-metadata">

**Author:** ![byramozgn](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@byramozgn](https://discourse.nodered.org/u/byramozgn)\
**Post date:** [19 October 2021 09:37 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/5 "2021-10-19T09:37:13Z")

</div>

thank you .

---

<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:** [19 October 2021 09:40 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/6 "2021-10-19T09:40:26Z")

</div>

So how do you want to display the data? in a list? in a graph? in a chart?

---

<div class="post-metadata">

**Author:** ![byramozgn](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@byramozgn](https://discourse.nodered.org/u/byramozgn)\
**Post date:** [19 October 2021 09:43 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/7 "2021-10-19T09:43:12Z")

</div>

I want to show in the list.

---

<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:** [19 October 2021 09:56 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/8 "2021-10-19T09:56:46Z")

</div>

Do you have the dashboard installed (`node-red-dashboard`)?  
what is the format of the data coming out of the sql node?  
Have you looked at the avaliable UI nodes (look in the left hand editor sidebar and scroll down towards the bottom)?  
You can even import some examples of some of the UI nodes to get a feel for how they work  
 ![Screen Shot 2021-10-19 at 5.54.03 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/6/16af8017a3ef538c2212f1fa355cdf245e4b1d28.png)

 ![Screen Shot 2021-10-19 at 5.54.41 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/0/f072b9422108793d37ded53104a70ea3760b80f1.png)

---

<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:** [19 October 2021 12:34 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/10 "2021-10-19T12:34:06Z")

</div>

You haven't answered all the questions I asked. If you want help, please answer all the questions so I don't have to repeat them.

---

<div class="post-metadata">

**Author:** ![byramozgn](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@byramozgn](https://discourse.nodered.org/u/byramozgn)\
**Post date:** [19 October 2021 12:38 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/11 "2021-10-19T12:38:18Z")

</div>

node-red-dashboard) yes installed.

In SQL, I only record real type data.

I have 2 columns in my table.  
id = int  
data=real  
names and data type like this.

---

<div class="post-metadata">

**Author:** ![byramozgn](https://avatars.discourse-cdn.com/v4/letter/b/34f0e0/32.png) [@byramozgn](https://discourse.nodered.org/u/byramozgn)\
**Post date:** [19 October 2021 12:42 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/12 "2021-10-19T12:42:26Z")

</div>

This is my table in mysql, so I want to see this table in my node-red ui layer.

 ![Ekran Alıntısı](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/d/8d46d431ccfa8776867e9d82ecebe3d44a81d00d.png)  
 ![g](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/d/5d7743c0c15e34f7c3ac544424c769d1a616969d.png)

I can add, update, delete in Mysql in my Node red flow. But I don't know how to use the table and transfer my data to the table.

---

<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:** [19 October 2021 14:38 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/13 "2021-10-19T14:38:02Z")

</div>

Have you looked at the ui-table node?

---

<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:** [18 December 2021 14:38 UTC](https://discourse.nodered.org/t/mysql-table-ui-layer-show/52401/14 "2021-12-18T14:38:47Z")

</div>

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