Skip to content
Advertisement

Tag: on-duplicate-key

how do i increment a value of column with condition?

my table looks something like this i have a function, which return 1to3 int value representing effect1,effect2,effect3 and “id” i am trying to increment value of each effect by 1 when my function’s returning “id” matches the “id” from my dataset otherwise creates new row and increase value of effect for example if my function returns (1,3) my table will

Advertisement