SQL DELETE Statement
IN SQL DELETE Query is used to
delete existing records in a table
DELETE Syntax -The Basic Syntax For DELETE table are as Follows
DELETE syntax for delete the specified record from the table
SQL>DELETE FROM table_name WHERE condition;
DELETE Synatx for record all the Column From the table
SQL>DELETE FROM table_name;
Delete A specify Record-
Example
SQL>DELETE FROM Student WHERE StudentName='Ram;
In above Query it will Delete the student whose name is ram from the
Student table .
Delete All Records
Example
SQL>DELETE FROM Customers;
In above Query it will Delete all the Row Present in Student table .it
Will Not delete the table just Delete
all the Column.