SQL DELETE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 13: Line 13:
|}
|}
The <code>DELETE</code> statement may contain a <code>WHERE</code> clause, that identifies the rows to be deleted: {{Internal|SQL_WHERE#Overview|The <tt>WHERE</tt> Clause}}
The <code>DELETE</code> statement may contain a <code>WHERE</code> clause, that identifies the rows to be deleted: {{Internal|SQL_WHERE#Overview|The <tt>WHERE</tt> Clause}}
=Conditional <tt>DELETE</tt>=
Also see: {{Internal|SQL_WHERE#SQL_Conditional_Logic|SQL Conditional Logic}}

Revision as of 20:01, 30 May 2024

Internal

Overview

DELETE FROM person WHERE id = 8;
PostgreSQL MySQL

The DELETE statement may contain a WHERE clause, that identifies the rows to be deleted:

The WHERE Clause

Conditional DELETE

Also see:

SQL Conditional Logic