SQL DELETE Statement
The DELETE statement is used to delete rows in a table.
DELETE FROM table_name WHERE some_column=some_value;
Note: The WHERE clause specifies which record or records that should be deleted.
DELETE FROM Customers WHERE CustomerName='Himanshu' AND ContactName='Divyanshu Nishad'
Delete All Data:
It is possible to delete all rows in a table without deleting the table.
DELETE FROM table_name;
DELETE * FROM table_name;
Learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.
- Lectures 41
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Self