Latest revision as of 21:11, 30 May 2024

Internal

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

Also see:

SQL Conditional Logic

@@ Line 2: / Line 2: @@
 * [[SQL#DELETE|SQL]]
 * [[SQL_WHERE#Overview|SQL <tt>WHERE</tt>]]
+=Overview=
+<syntaxhighlight lang='sql'>
+DELETE FROM person WHERE id = 8;
+</syntaxhighlight>
+:{| class="wikitable" style="text-align: left;"
+|-
+| [[PostgreSQL_DML_Operations#DELETE|PostgreSQL]] || MySQL
+|-
+|}
+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_Conditional_Logic#Overview|SQL Conditional Logic}}