MySQL Delete Statement

MySQL DELETE statement allows you to delete existing records in a table within the database. By using delete statement, we can delete records on the basis of conditions.

MySQL DELETE TABLE Syntax

To detele data from existing table, use the following syntax:

DELETE FROM tablename WHERE Condition;

Parameters:

tablename: The table name from which you want to delete the data.

Condition: To check specific condition before delete the data. The conditions parameter is optional.

MySQL DELETE TABLE Data example

DELETE FROM tblCustomerLoan WHERE firstName = 'Sunil' AND lastName = 'Shetty';

Note:

In the above example, we have deleted the record for customer "Sunil Shetty".

You can use MySQL Command Line Client to delete data from "tblCustomerLoan" table. It will look like this:

Show DELETE Data Example

SELECT * FROM  tblCustomerLoan; 

You can use MySQL Command Line Client to check the deleted data in table. It will look like this:

MySQL DELETE Data example for all records

DELETE FROM tblCustomerLoan;

OR

DELETE * FROM tblCustomerLoan;