MySQL DELETE Statement

Estimated reading: 1 minute 763 views

The SQL DELETE Statement

The DELETE statement is used to delete existing records in a table.

DELETE Syntax

				
					DELETE FROM table_name WHERE condition;

The following SQL statement deletes the customer “Alfreds Futterkiste” from the “Customers” table:

				
					DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

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:

				
					DELETE FROM table_name;

The following SQL statement deletes all rows in the “Customers” table, without deleting the table: