WHERE Column = Value;
What does it do?
The DELETE statement will delete all rows that are selected by the WHERE
constraint. If the Where clause is omitted, all the rows
in the table will be deleted. It is very important to add a WHERE clause
for the DELETE statement.
Note: You cannot select specific columns to be deleted with this statement,
therefor an asterisk(*) is always used in place of columns.
WHERE CustomerID = 5;
Blue - Is used to identify reserved keywords/characters that are used
by the SQL engine, i.e. SELECT, FROM, or WHERE.
Purple - Is used to identify portions of the SQL statement
that are defined by the user, i.e. Column Names, Table Names, Inputed Values.