In MySQL, The DELETE statement is used to remove one or more records from a table.
DELETE FROM table_name WHERE condition;
table_name: The name of the table from which we want to delete records.
WHERE: Specifies the condition that must be satisfied for the deletion to occur. If we omit the WHERE clause, all records in the table will be deleted.
DELETE FROM products WHERE product_code = 1001;
Note: the record with "product_code" equal to 1001 will be deleted from the products table.
DELETE FROM table_name;
Note: However, be cautious when using DELETE without a WHERE clause, as it will delete all records in the specified table.