a apiary.
← All tools

SQL / BROWSER UTILITY

SQL UPDATE Builder

Build UPDATE statements with SET fields, WHERE conditions and an explicit warning for unrestricted changes.

Processed locally in your browser. Your SQL is not uploaded or executed.

Enter names, not expressions. Use dialect quotes around names with spaces. Ordinary Oracle names use uppercase; ordinary PostgreSQL names use lowercase. Text values are escaped, never executed.

SET fields
WHERE conditions

Conditions are combined from top to bottom, with explicit parentheses. Remove all conditions only if you intend to affect every row.

Apiary never executes SQL. Review the statement against your database before using it. Oracle treats empty text as NULL. SQLite uses type affinities and does not enforce declared text lengths or decimal precision.

Good to know

Set one or more fields and combine conditions from top to bottom. Without a WHERE clause every row is affected, and copying requires acknowledgement. Apiary never executes SQL.

Example: Set product_name to Notebook where product_id equals 42.