SQL DELETE

The SQL DELETE Clause is used to delete rows in a table.
With some condition being set with the DELETE clause, all data that meet the condition will be deleted.

DELETE is not limited to one row at a time. We may delete any or all rows that apply to our conditional together.

The DELETE clause syntax:

DELETE FROM [TABLE NAME]
WHERE [COLUMN NAME] = [CONDITION]

EXAMPLE :

We can try to DELETE the records for Player Kenny in the table below.

Table GameScores

SQL statement :

DELETE FROM GameScores
WHERE PlayerName = 'Kenny'

After execute the SQL command. The table will look like like this. As we can see the record for Kenny already Deleted.

Table GameScores

If you wish to DELETE all rows inside a table.

The SQL Statement will be like this:

DELETE FROM GameScores