To delete a record, not surprisingly, you use the DELETE statement. Its syntax is very simple. All you specify is the table and a condition. For example,
DELETE FROM Users WHERE UserID = 10
would delete all records in the Users table which had a UserID of 10. Likewise,
DELETE FROM Furniture WHERE Price < 10
would delete all records in the Furniture table which had a price of less than 10.
Comments