UPDATE
DestructiveUpdate rows
UPDATE <table> SET ... WHERE ...;
Updates rows matching a condition; a missing WHERE updates every row.
Examples
UPDATE users SET active=0 WHERE last_login<'2025-01-01';Disable stale users
Syntax
UPDATE <table> SET <col>=<val> WHERE <cond>;
Before you run it
Without WHERE, all rows change; always verify.
Related commands
- SELECTRead data
- Dump / backupBack up a DB
Check it once more before you run it
Some commands cannot be undone if one flag is wrong. An on-device reference works with no connection. Free to install, no ads.
Get it free on the App Store