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] [2]

Which element will I use in the UI layer?

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 . 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 inv…

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

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 ge…

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.

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.

This is my table in mysql, so I want to see this table in my node-red ui layer. [Ekran Alıntısı] [g] 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.

Node-RED

Node-RED Forum

Mysql table UI layer show?

General

zenofmud 19 October 2021 09:08 2

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)

Topic		Replies	Views
Show data on ui-table coming from SQL database General	7	3226	8 May 2022
Extract SQL data from database General	10	6691	20 December 2021
How can i create a table from a DB? General	9	1168	18 June 2020
How display data on a table on the UI of node red General	3	483	26 May 2020
How to bring data from MySQL to Node red in a dashboard General node-red-dashboard , database	2	417	10 June 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Mysql table UI layer show?

Related topics