Examples
Delete rows from table pies where the column flavour equals Lemon Meringue:
DELETE FROM pies WHERE flavour='Lemon Meringue';Delete rows in trees, if the value of height is smaller than 80.
DELETE FROM trees WHERE height < 80;Delete all rows from mytable:
DELETE FROM mytable;Delete rows from mytable using a subquery in the where condition:
DELETE FROM mytable WHERE id IN ( SELECT id FROM mytable2 );Delete rows from mytable using a list of values:
DELETE FROM mytable WHERE id IN ( value1, value2, value3, value4, value5 );Read more about this topic: Delete (SQL)
Famous quotes containing the word examples:
“No rules exist, and examples are simply life-savers answering the appeals of rules making vain attempts to exist.”
—André Breton (1896–1966)
“It is hardly to be believed how spiritual reflections when mixed with a little physics can hold people’s attention and give them a livelier idea of God than do the often ill-applied examples of his wrath.”
—G.C. (Georg Christoph)
“Histories are more full of examples of the fidelity of dogs than of friends.”
—Alexander Pope (1688–1744)