SQL DELETE: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
 
Line 14: Line 14:
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>=
=Conditional <tt>DELETE</tt>=
Also see: {{Internal|SQL_WHERE#SQL_Conditional_Logic|SQL Conditional Logic}}
Also see: {{Internal|SQL_Conditional_Logic#Overview|SQL Conditional Logic}}

Latest revision as of 21:11, 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