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
353
March 29, 2020 07:25AM
185
March 29, 2020 11:59AM
183
March 29, 2020 09:18PM
182
March 30, 2020 12:26AM


Sorry, you can't reply to this topic. It has been closed.

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.