I have some fields in my DB that when a certain thing happens I just want to increment the value in it by a number.
Say the field contains this: 3
After the action I want to add 1 to it so that it will now be this: 4
I have set the field to an INT but I am not sure what kind of SQL statement I would need to write.
Would I use UPDATE to change it or is there some kind of command where I can just INCREMENT it or something?
Thanks for any help!