Revision as of 20:00, 30 May 2024

Internal

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

Also see:

SQL Conditional Logic

@@ Line 13: / Line 13: @@
 |}
 The <code>UPDATE</code> statement may contain a <code>WHERE</code> clause, that identifies the rows to be modified: {{Internal|SQL_WHERE#Overview|The <tt>WHERE</tt> Clause}}
+=Conditional <tt>UPDATE</tt>=
+Also see: {{Internal|SQL_WHERE#SQL_Conditional_Logic|SQL Conditional Logic}}