SQL · Writing data

update

Changes matching rows. Always include a precise WHERE clause and check the affected count.

sqlRunnable example sql course

Syntax

update table set col = value where …;

Example

Open in the lab

CREATE TEMP TABLE notes (id INTEGER PRIMARY KEY, body TEXT);
INSERT INTO notes (body) VALUES ('draft');
UPDATE notes SET body = 'published' WHERE id = 1;
SELECT * FROM notes;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

update

Example

More in this group

Learn this in the course