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.
DELETE FROM nameoftable;
DELETE FROM items;
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;