SQL UPDATE: Difference between revisions
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
|- | |- | ||
|} | |} | ||
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}} | ||
Revision as of 23:30, 22 May 2024
Internal
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: