There are two tables: rating and rating. I need after changing the data in the evaluation table field evaluation, update the rating field in the rating table. That is, who has the highest score in addition rating 1, and so on. How to implement it correctly?

    1 answer 1

    The best way to do this is by using the ON UPDATE and ON INSERT event triggers (if you expect to add data) to the rating tables.