MySQL Forums
Forum List  »  General

Find data after a failed trigger
Posted by: Evgeniy S
Date: August 02, 2024 05:53AM

Structure: There is a last_user_actions table and a user_actions table. The user_actions table has a trigger update_last_user_actions that updates the data after insert in the last_user_actions table.

Problem: The problem is that a new column was added to the last_user_actions table, but without a default value, as a result, new data was not entered either in user_actions or in last_user_actions because I forgot to set default value for new column.

Question: How can I find data that could not be successfully recorded?

Options: ReplyQuote


Subject
Written By
Posted
Find data after a failed trigger
August 02, 2024 05:53AM


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.