Update Rows

Modify existing rows with `UPDATE`, then verify the changed data with a stable query.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Update one matching row

The WHERE clause is the safety boundary. Without it, the update would touch every row in the table.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE users (id INT, status VARCHAR(20));

INSERT INTO
  users (id, status)
VALUES
  (1, 'pending'),
  (2, 'active');

Validated query Shared across supported engines.

SQL

UPDATE users
SET
  status = 'active'
WHERE
  id = 1;

SELECT
  id,
  status
FROM
  users
ORDER BY
  id;

Expected result Returned rows for the shared example.

id	status
1	active
2	active

The verification output matches, but the execution blocks differ so the final captured table state stays deterministic.

Useful when

Where this command helps.

changing status or ownership fields on existing rows
backfilling corrected values after a data cleanup

Explanation

What the command is doing.

UPDATE changes data that already exists. In teaching content, it is usually clearer to show the table after the update instead of relying on engine-specific row count messages.

Update Rows

Update one matching row

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.