Re: access to other columns though other table's foreign key
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.
Subject
Written By
Posted
Re: access to other columns though other table's foreign key
June 17, 2022 09:43AM
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.