I have two tables in mysql
Table: objects
1: ID (Auto Increment) INT eg: 1 2: Object (like "Flower) TEXT eg: Flower 3: Rank (like 90, calculated) FLOAT eg: 90
Table: Rankings
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 Table2
where Object = Object.Table1
. In this case it would be 90
for the Flower
.
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.