SQL as Data Manipulation Language SQL as Data Manipulation Language: Besides of retrieving data from database using SELECT statement, SQL also provide the statements to manipulate the data of…
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:
[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’.