MySQL Forums
Forum List  »  Newbie

Re: access to other columns though other table's foreign key
Posted by: Peter Brawley
Date: June 17, 2022 09:43AM

Triggers are often used for validation. Before 8.0, it was that or app code. Given the limitations on MySQL's implementation of Check Constraint, Triggers are sill widely used. A big advantage of a Trigger over app code is that you don't have to worry about inputs escaping validation enforcement.

Options: ReplyQuote


Subject
Written By
Posted
Re: access to other columns though other table's foreign key
June 17, 2022 09:43AM


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.