Save data from retool column to mysql column

App Building
1

Hi,

I have editable column in my table, and i want to take value entered by a user and save it mysql, so the value would be kept and wont be left empty after page is refreshed. No i have this query: UPDATE
info
SET
user_notes = {{table.selectedRow.user_notes}}
WHERE
name = {{table.selectedRow.name}}

which is being triggered with a button save. But the values are not being saved. Table displays data from sql.

1 Like
2

how do you do to query in sql in a massive way the data of all the rows of a column you have in a table ?