devxlogo

Trigger for Updating the Table of the Trigger

Trigger for Updating the Table of the Trigger

Question:
I would like it that every time I insert a row in table A, another row of the same table must be updated according to the values of the row I’m inserting. What’s the best way to do this? It’s impossible for me to do it with triggers?to update a row of the same table in which I define the trigger.

Answer:
Try using an intermediary table. Table A has a trigger that updates Table B. Table B has a trigger that updates Table A.

I haven’t tried this, and I seem to remember somewhere that the engine will not allow such loops, but it’s worth a try.

See also  Small Business Strategies with Venmo
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist