DELETE keyword in SQL helps to remove records from the database. It is different from DROP keywords as DELETE Clause removes the values from the table but, DROP is used to remove the entire table.
Syntax:
DELETE from Table_name;The use of the above syntax can delete the entire record present in the table.
DELETE from Table_name
WHERE Condition...;DELETE with WHERE Clause helps to remove the records as per the condition applied.
Example: Delete based on condition
From the previous example of Stu Table:
DELETE from Stu where Name='Shruti';Output:
Example: Delete all records in a table
DELETE from Stu;Output:
All records in stu table has been deleted.