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.
To detele data from existing table, use the following syntax:
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.
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:
You can use MySQL Command Line Client to check the deleted data in table. It will look like this: