Thursday, April 14, 2016

Sql Delete

SQL Delete use for delete existing rows the from table .You need to use where clause for delete rows because without where clause it delete whole rows from the table. You can use AND or OR for deleting condition.

Following this query, which  delete which student ID is 1.

Delete from Stu_Info  where stu_Id = 1;

Following this query, which  delete all the rows from the table.

Delete from Stu_Info;

No comments:

Post a Comment