Deleting Rows from Tables
Learn how to delete data from the table.
We'll cover the following...
Syntax for the delete
query
Let’s look at the delete
query below:
- The
delete
keyword is used to delete any data from the table. - This item tells us which table we want to delete data from. In this case, it’s
customers
. - The
where
clause is given at thedelete
statement between the table name and the condition, depending on what data we want to delete. - In the end, we impose the condition to delete the record,
name = "John papa"
.
Let’s learn more about the delete
command. What if we wanted to delete the customer with the name John Papas
?
We can use the following command to delete a ...