Update Rows
AI-generatedSummary
Update existing rows in a specified database table within CloudBeaver by executing an UPDATE SQL statement with user-defined column-value pairs and an optional WHERE clause.
Inputs
- Connection ID (required) — The CloudBeaver database connection ID to use; obtain it by right-clicking the database in Database Navigator and selecting Open.
- Default Database — The specific database or catalog to use for the SQL execution; leave empty to use the connection's default.
- Database Type — Type of database (PostgreSQL, MySQL, SQL Server) to determine proper SQL identifier quoting.
- Schema — Database schema containing the table; omit to use no schema prefix.
- Table (required) — Name of the table where rows will be updated.
- Update Fields (required) — One or more columns to update with their corresponding values and value types (string, number, boolean, null, or raw SQL).
- WHERE Clause — Condition to specify which rows to update; leave empty to update all rows.
- Query Timeout — Maximum seconds to wait for the update query to complete (default 60 seconds).
Output shape
a list of JSON objects indicating success or error for each input item
Returns an array with success status for each update operation paired to the input item index. If an error occurs and 'continueOnFail' is enabled, errors are returned instead of stopping execution.