SQL UPDATE

Internal

• SQL
• SQL WHERE

Overview

UPDATE person SET name = 'Binh Ngo Jr.', city = 'San Francisco' WHERE id = 1;

PostgreSQL

MySQL

The UPDATE statement may contain a WHERE clause, that identifies the rows to be modified:

The WHERE Clause

Conditional UPDATE

Also see:

SQL Conditional Logic