Learn MySQL for Developing Web Application

SQL DELETE Query

---

The SQL Delete Statement

The SQL DELETE statement is used to delete rows from a table. Generally DELETE statement removes one or more records from a table.

SQL DELETE Syntax

Let's see the Syntax for the SQL DELETE statement:

Here table_name is the table which has to be deleted. The WHERE clause in SQL DELETE statement is optional here.

---

Delete All Records

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:

or:

---