Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

SQL DELETE ROW


Let us take an example of student.

Original table:

ID STUDENT _NAME ADDRESS
001 AJEET MAURYA GHAZIABAD
002 RAJA KHAN LUCKNOW
003 RAVI MALIK DELHI

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

  1. DELETE FROM student_name
  2. WHERE id = 003;

Resulting table after SQL DELETE query:

ID STUDENT_NAME ADDRESS
001 AJEET MAURYA GHAZIABAD
002 RAJA KHAN LUCKNOW

Comments

comments