Create after update trigger
So I have the following problem.
The problem concerns 3 columns: upvote, downvote, score where `score` is created by taking upvote/downvote
I now want to create a trigger which will update my `score` column after either the `upvote` or the `downvote` where updated.
I looked at a bunch of stuff online and tried several things but never got it to work.
Including something like this.
create trigger trigger1 after update of (up or down) on table1 for score
set new.score =concat(up/down);
I've never created triggers before so this is completely new for me.