How to create an editable MySql table? I want CRUD operations: to list all the rows of table, add new rows, update values, and delete record.

Those are perfectly usual actions on an SQL database, accomplished by suitably formatted INSERT, SELECT, UPDATE and DELETE SQL statements. If you install and use node-red-node-mysql the SQL should be created as msg.topic. For example msg.topic = "UPDATE employees SET salary = salary * 2 WHERE emp…

This is rather a non-trivial exercise I'm afraid. I am assuming that you want an end-user accessible page that displays the table and then allows changes to be made? Displaying the table is pretty easy with a dashboard table node - as long as the source data isn't very large. If it is large, you w…

Node-RED

Node-RED Forum

Edit mysql table

General

E1cid 24 February 2024 19:23 4

This post may give you some ideas. It shows how to add pagination in ui-table, and editing table data. both ui-table and a ui-template html table. UI Template Edit msg.payload then Output - #4 by E1cid

Topic		Replies	Views
Write and Read an editable table General	10	3400	9 April 2021
SQLite Browser based manager General	13	2312	18 June 2020
Modify database table Dashboard dashboard-2	5	307	7 May 2024
Form node / class Industrial	4	482	20 April 2022
Update table rows in dashboard Dashboard	8	172	17 May 2025

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.

Edit mysql table

Related topics