# How to edit table content (SQL query)

**URL:** <https://forum.inductiveautomation.com/t/how-to-edit-table-content-sql-query/103493>\
**Category:** Maker\
**Tags:** ignition80, perspective, database, ignition81\
**Created:** [March 11, 2025, 7:16am UTC](https://forum.inductiveautomation.com/t/how-to-edit-table-content-sql-query/103493 "2025-03-11T07:16:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vidar\_Hetlelid](https://avatars.discourse-cdn.com/v4/letter/v/dfb087/32.png) [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\
**Post date:** [March 11, 2025, 7:16am UTC](https://forum.inductiveautomation.com/t/how-to-edit-table-content-sql-query/103493/1 "2025-03-11T07:16:29Z")

</div>

Hello there,

I have some tables which is SQL query. Is it possible for user to just click on the cells, to edit the content? And it automatically gets written to the MySQL database? If so, how can I accieve this? 🙂

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/4/54f60ef8d3ba195382e9932a18df5c240ba53b22.png)

---

<div class="post-metadata">

**Author:** ![diamond](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@diamond](https://forum.inductiveautomation.com/u/diamond)\
**Post date:** [March 11, 2025, 9:18am UTC](https://forum.inductiveautomation.com/t/how-to-edit-table-content-sql-query/103493/2 "2025-03-11T09:18:39Z")

</div>

[How to edit table columns in Perspective - Ignition by Inductive Automation](https://www.youtube.com/watch?v=wiHMzrWvk_g)

Just adapt the script to perform an UPDATE in your database.