DELETE Query is used to Delete rows from Database Table. When executing a delete statement for certain records only the WHERE clause is also required. This will determine which records to delete, otherwise all records on the table will be deleted.
SYNTAX:
DELETE FROM nameoftable;
EXAMPLE:
DELETE FROM items;
DESCRIPTION:
DELETE query is used to delete all records from a table. We can also delete some specific records by using WHERE condition with DELETE. For example
DELETE FROM items WHERE ItemID=1;