How to delete rows

pre> DELETE [FROM] table_name [WHERE search_condition]

      DELETE FROM products WHERE productID = 6;
      

      DELETE FROM products WHERE categoryID = 3;
      

      DELETE FROM categories WHERE categoryID > 3;
      

      DELETE FROM orderItems 
      WHERE orderID IN (
        SELECT orderID FROM orders WHERE customerID = 1
      );
      

Description

• You can use the DELETE statement to delete one or more rows from the table you name in the DELETE clause.
• You specify the conditions that must be met for a row to be deleted in the WHERE clause.
• You can use a subquery within the WHERE clause.

Warning

• If you omit the WHERE clause from a DELETE statement, all the rows in the table are deleted.