I have two tables in mysql
1: ID (Auto Increment) INT eg: 1 2: Object (like "Flower) TEXT eg: Flower 3: Rank (like 90, calculated) FLOAT eg: 90
1: ID (Auto Incement) INT eg: 1,2,3,4,5, 2: Object (like "Flower") TEXT eg; Flower,Flower,Flower,Flower,Flower 3: Person (like "Peter") TEXT eg: Peter,Hans,Markus,Emil,Egon 4: Ranking ( +/- Points) FLOAT eg: 100, -10 , -10 , -10 , 20
So, The Rank from Table1, is a sumary of all Rankings in
Object = Object.Table1. In this case it would be
90 for the
How can I build a trigger (on insert) for this? Every time someone posts a ranking the
Rank.Table1 gets updated via a trigger.
Sorry for this question, but I'm very new to this.