How to use [mysql.update]
The reference page of mysql.update has its arguments, constraints and declaration.
This slot updates records in a table, generating the SQL for MySQL, and resolves to the number of records affected. It works like [data.update]. Always supply [where], or every record in the table is updated. Below is an example.
mysql.connect:sakila
mysql.update
table:actor
values
last_name:Smith
where
and
first_name:John
last_name:Doe