Forsiden
Beliggenhed og kontakt
Åbningstider
Menu
Books & References
DELETE
The DELETE statement is used to delete rows in a
table. It is similar to the SELECT statement having
three main clauses namely

*DELETE
*FROM
*WHERE

The syntax for the DELETE statement

DELETE FROM <table name> WHERE <condition>

Using the DELETE statement we can delete all the rows
in a table, this is achieved by the following syntax:

DELETE * FROM <table name>