UPDATE
Updates existing rows.
Syntax
UPDATE table SET column=value WHERE condition;
Description
Updates ALL rows without WHERE — watch out! You narrow down the target with WHERE.
Example
Loading editor…
Expected output
Alex L.
When to use?
Updating records.
Common mistakes
- ⚠️ UPDATE without WHERE modifies all rows — be very careful.