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.
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.