Revision as of 21:11, 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 14: / Line 14: @@
 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}}
+Also see: {{Internal|SQL_Conditional_Logic#Overview|SQL Conditional Logic}}