Mysql Trigger After Delete

Trigger in Mysql fired trigger automatically after you perform Delete
Operation on Table.

Understand with Example

The Tutorial illustrate an example from 'Trigger After Delete' in Mysql. To
understand this example, we create a table 'Employee'. The create table
'employee' is created with different field name and data type respectively.

Again, we use same select Query to return the
records from a table employee_log.

mysql> select * from employee_log;

Output:-

Empty set (0.00 sec)

Create Trigger:-

Drop Trigger is used to delete trigger
Employee_Trigger from database, in case if there is any trigger existing
on this name. The 'Employee_Triger' fired trigger after you perform a
delete operation on table 'employee'. The deleted records from table 'employee'
copy into a table 'employee_log'.