Trigger Execution examples in mysql

By | January 14, 2015

We have two database tables. while updating the table entry trigger will execute.

tbl_experience
tbl_salary

after updating the experience in the tbl_experience table. automaticaly update the salary column in the tbl_salary

Step1:
Use the below code to create tables through phpmyadmin-paste the below code into the query window.

Step2: execute the below script through SQL run winodow in phpmyadmin

Step3: Goto phpmyadmin browse the table tbl_experience and edit some records.
check the table tbl_salary you can see some updates in the salary field

Enjoy 🙂

Please share this tutorials with your friends