MySQL Delete Statement

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

MySQL DELETE statement is used to delete data from the MySQL table within the database.

By using delete statement, we can delete records on the basis of conditions.

 
 DELETE FROM table_name    
 WHERE   (Condition specified);

This table named Students in our database that contains the following records:

Let's check out some examples that demonstrate how it actually works

 
DELETE FROM Students  
WHERE ROLL_NO = 6;

The following MySQL statement will Delete the record of student with ROLL_N0 = '6'

After execution, the resulting table will look something like this:

« Previous Next »

MySQL - Delete Statement