SQL DELETE Statement

The DELETE Statement

The DELETE statement is used to delete rows in a table.

DELETE FROM tableName WHERE columnName = someValue;

From this "Books" table:

The book having the title "Linux Distributions" is going to be deleted:

DELETE FROM Books WHERE Title = 'Linux Distributions';

The result is:

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:

DELETE FROM tableName;

To test your SQL skills click here.