Deleting Data from MySQL Database

Data can be deleted from MySQL tables by executing SQL DELETE statement through PHP function mysql_query.

Below is a simple example to delete records into employee table. To delete a record in any table it is required to locate that record by using a conditional clause. Below example uses primary key to match a record in employee table.

Example

Try out following example to understand delete operation. You need to provide an employee ID to delete an employee record from employee table.

   
   
      
   
   
   
      
               

                  

                     
                     

                        
Employee ID