MySQL Trigger to prevent update in one table if particular data is available in another table
0
votes
1
answer
1865
views
I need a MySQL trigger that can prevent update of a particular column data, if some specific data is available in another table.
I have two tables product and sales.
**Product**
**Sale**
I need to prevent the update of updated_at column in product table if the product_id is available in sale table.


Asked by PRAMOD MANN
(13 rep)
Jul 29, 2022, 05:21 PM
Last activity: Jul 30, 2022, 07:49 AM
Last activity: Jul 30, 2022, 07:49 AM