database modify element in row

[jyang72211]

Hi all,

I have a question about the database toolkit.  How do I query a particular row in a table and modify an element in that row?  By doing this, the database table is getting updated.

Yik

[Dennis_Knutson · Accepted solution]

You use the Execute Query and do an UPDATE

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

[jyang72211]

When I write sql query, I always use it to get data, and I have never tried to update a table in a database.  I didn't know that you can use the querying function to update a table.  Thanks, it worked.

Yik