SQL · Writing data

update from

Updates rows using values from another table. PostgreSQL syntax; SQLite uses UPDATE … FROM as well.

sqlRunnable example sql course

Syntax

update t set x = s.x from source s where …

Example

Open in the lab

CREATE TEMP TABLE notes (id INTEGER, body TEXT);
CREATE TEMP TABLE edits (id INTEGER, body TEXT);
INSERT INTO notes VALUES (1, 'old');
INSERT INTO edits VALUES (1, 'new');
UPDATE notes SET body = edits.body FROM edits WHERE notes.id = edits.id;
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 from

Example

More in this group

Learn this in the course