Safe Update

-- Drill 15 — UPDATE آمن بشرط WHERE — SQLite 3.x+
CREATE TABLE orders (
  id INTEGER PRIMARY KEY,
  status TEXT NOT NULL
);

INSERT INTO orders VALUES (1, 'draft'), (2, 'draft');

UPDATE orders
SET status = 'paid'
WHERE id = 1;

SELECT id, status
FROM orders
ORDER BY id;