MySQL Forums
Forum List  »  Triggers

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

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

Written By
Trigger Using PHPMyAdmin
March 29, 2020 07:25AM
March 29, 2020 11:59AM
March 29, 2020 09:18PM
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.