SQL – DELETE order: Learn about the DELETE order, its syntax examples and so on with questions.
Erase articulation is used to erase a record from the table or erase the entire table.
Erase is a Data Manipulation Language (DML) order which implies it just chips away at the information not on the structure for example on the off chance that the information of the entire table is erased even, at that point the table exists implies its structure doesn’t get erased
Syntax:
Here,
table_name: name of the table.
condition: condition as indicated by which a specific record is chosen.
Queries
Erase all the records from the table
DELETE FROM Student;
The above explanation will erase all the information/records/understudy from the table Student.
Erase different records from the table
For example: If we need to erase all the understudies who live in the City Gwalior then the accompanying explanation will be utilized
DELETE FROM Student WHERE City=’Gwalior’;
