UPDATE SET

Modify existing rows

Mutation

SQL

UPDATE users SET email = '[email protected]' WHERE id = 1;

What each clause does

UPDATE identifies the table. SET assigns new values to columns. WHERE limits which rows are modified.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET