If the DELETE clause is executed without adding the where condition, all the data in the table is DELETED.<\/p>\n
Since we will work in the ogrenci_d1 table, let’s look at the data in the table.<\/p>\n
![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/delete1.png\")
<\/p>\n
Let’s delete all the data specified in the ogrenci_d1 table with DELETE.<\/p>\n
DELETE FROM ogrenci_d1;<\/pre>\nWhat should I do if I want to delete the student whose name is Faruk? We will use the where condition right here, let’s make our example of the where condition.<\/p>\n
DELETE FROM ogrenci_d1 WHERE name='Faruk';<\/pre>\nAs seen above, our record named Faruk is not visible.<\/p>\n
We can use the RETURNING command to see the deleted data, let’s delete one more data, but let’s see the deleted data by using the RETURNING command.<\/p>\n
DELETE FROM ogrenci_d1 WHERE name='Ogun' RETURNING *;<\/pre>\nAs seen in the picture above, we deleted our data and let’s look at the output of the deleted data by selecting our table.<\/p>\n
<\/div>\n