SQL DELETE ROW

Let us take an example of student.

Original table:

IDSTUDENT _NAMEADDRESS
001AJEET MAURYAGHAZIABAD
002RAJA KHANLUCKNOW
003RAVI MALIKDELHI

If you want to delete a student with id 003 from the student_name table, then the SQL DELETE query should be like this:

DELETE FROM student_name  

WHERE id = 003;

Resulting table after SQL DELETE query:

IDSTUDENT_NAMEADDRESS
001AJEET MAURYAGHAZIABAD
002RAJA KHANLUCKNOW

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *