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 *