SQL DELETE: Difference between revisions
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
DELETE FROM person | DELETE FROM person WHERE id = 8; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" |
Revision as of 00:16, 23 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: