SQL UPDATE: Difference between revisions
Jump to navigation
Jump to search
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}} | 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>= | =Conditional <tt>UPDATE</tt>= | ||
Also see: {{Internal| | Also see: {{Internal|SQL_Conditional_Logic#Overview|SQL Conditional Logic}} |
Revision as of 21:11, 30 May 2024
Internal
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:
Conditional UPDATE
Also see: