DELETE query in MySQL
MySQL DELETE: The MySQL DELETE statement is used to eliminate data records from a table. Syntax: DELETE FROM table_name WHERE conditions; Example: Items table before deletion: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 3 Fashion 100 4 Grocery 90 5 Toys 50 DELETE FROM items WHERE id = 3; Explanation: The ‘items’ … Read more