MySQL Forums
Forum List  »  Triggers

Trigger Using PHPMyAdmin
Posted by: Great Chap
Date: March 29, 2020 07:25AM

Hello,
I am running MySQL 5.6. I want to know which row/rows have been updated in a table [After Update]. One way is to create a trigger using PHPMyAdmin. This trigger can store row id (id is a table column) of that row and current datetime into another table. This way I will know which record has changed. In PhpMyAdmin when I add trigger it asks me event, time and table which I fill. But what do I write in Definition & Definer.

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger Using PHPMyAdmin
136
March 29, 2020 07:25AM
71
March 29, 2020 11:59AM
72
March 29, 2020 09:18PM
68
March 30, 2020 12:26AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.