Delete SQL Tutorial

Delete Syntax:

DELETE FROM table_name WHERE {condition}

IF you don't put the {condition} then all the records from the table will be erased.

Store table:

OBJECT_IDPRICENAME
1200A
2500B
3900C
4500D

Example:

DELETE FROM store WHERE price=500;

SELECT * FROM store;

OBJECT_IDPRICENAME
1200A
3900C