[ajwar]

Hi, how to increase field value by 1 with mysql query?

[THE_KNOWN]

get the value first, store it, add it , update it simple

[XFlawless]

AUTO_INCREMENT

[ajwar]

i know it's possible withaut getting the value, it's something like that:

pawn Код:

format(Query1, sizeof(Query1), "UPDATE `usrinv` SET `user_invited` +1 WHERE `user_code` = '%i' LIMIT 1", code);

[-Rebel Son-]

Update a value like so

Either +1
or ++