The UPDATE statement supported by UnityJDBC has the following syntax:
UPDATE
UPDATE <tbl_name> SET col1=expr1, col2=expr2, ... [WHERE <condition>];
An example is below:
UPDATE Employee SET salary=salary*1.10 WHERE age > 50;