MySQL Delete Statement

MySQL Delete statement simply deletes values meeting the given conditions. 

MySQL Delete Syntax
DELETE FROM table_name WHERE [Conditions]

Example

ID Product Name Price £ Description
1 3D Glasses 14.49 High quality 3D glasses for 3D projectors.
2 Projector 400 HD and 3D ready Home teather projector.
3 Projector Screen 60 Perfect home teather experience with 90'' screen.
4 Sound System 800
High quality sound system.

Lets delete the 4th row where ID is equal to 4

mysql> DELETE FROM products WHERE ID=4;

ID Product Name Price £ Description
1 3D Glasses 14.49 High quality 3D glasses for 3D projectors.
2 Projector 400 HD and 3D ready Home teather projector.
3 Projector Screen 60 Perfect home teather experience with 90'' screen.

Deleting all the rows

mysql> DELETE FROM products;

Now the products table is an empty set.