Thursday, 29 August 2013

How to update multiple tables and fields in a Trigger?

How to update multiple tables and fields in a Trigger?

I have the following schema : SQL Fiddle.
The trigger is updating the articles.votes field. I also need it to update
the members.points field and the members lifetime_points fields with the
same formula as updates the articles.votes field. How do I do that?

No comments:

Post a Comment