Deleting Record: The existing record in a table is removed from the table using DELETE , command. Entire record or specified columns in the table can be deleted. If we want to perform delete operation on specific columns, then that condition is given in the WHERE condition. If the condition is not specified, then the entire data will be deleted.
Syntax: DELETE from tablename WHERE columnname= “value”;