4 ms·
An ON UPDATE trigger for the is_deleted column would do. Some databases also support INSTEAD OF triggers.
by nine_k 5y ago
An ON UPDATE trigger for the is_deleted column would do.
Some databases also support INSTEAD OF triggers.
- vaishnavsm 5y agoDoesn't ON UPDATE only work for foreign keys? As far as I know, it's used to update the foreign key itself, and not values based on relationships.
- deleted 5y ago[deleted]