DELETE Statement In Database

Delete statement In Database: The DELETE statement is used to delete rows from database table. The rows are permanently deleted and cannot be recovered again. The genera syntax of this statement is:

DELETE FROM

[WHERE ]To delete a row from STUDENT table with the roll number 123, the SQL statement is written as:DELETE FROM student WHERE Roll_No = 123To delete record which have value “Lahore” in ‘City’ attribute in STUDENT table the SQL statement is written as:DELETE FROM student WHERE City = ‘Lahore’.