SQL UPDATE

Internal

• SQL
• SQL WHERE

Overview

UPDATE person SET name = 'Binh Ngo Jr.' WHERE id = 1;

PostgreSQL

MySQL

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

The WHERE Clause