In this lesson, we  will process the DELETE command. Delete command means to delete in English. As the name suggests, it is a command that we use to delete records. It is very simple and easy to use.
Usage: We write DELETE then I write FROM . There is a rule to be considered here. We do not use the * sign here, we call direct delete . Then we write the name of the table from which table we will delete.
Let's show this with examples.
First I called select * from contacts and called my contacts table.
Then I said DELETE FROM contacts and deleted all the data in my table.
You can see in Picture 2

As it can be seen from the picture, it states that 4 rows in my table have been deleted.
The delete command is used in this way.
Good work to everyone.

Yorum Yap

Daha yeni Daha eski