MySQL Forums
Forum List  »  Triggers

Before Update Trigger prevents further edit in MySQL 8.0
Posted by: David Harrison
Date: December 15, 2019 05:12PM

I've create a simple table with a date time column to track when a row has been changed. I created a before update trigger to set that column to NOW().
The trigger works as expected, however I am no longer able to edit the table definition inMySQL Workbench. I get an error message "Error getting DDL for object - Lost connection to MySQL server during query". When I drop that trigger I am able to edit the table again.

Options: ReplyQuote


Subject
Views
Written By
Posted
Before Update Trigger prevents further edit in MySQL 8.0
198
December 15, 2019 05:12PM


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.