Sample Header Ad - 728x90

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** enter image description here **Sale** enter image description here 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