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.