Works like a charm in mysql:
UPDATE mytablename SET myint = myint + 1 WHERE id = 1
Of course, decrement is also possible
Tuesday, September 20th, 2011 | SQL | RSS 2.0 feed
Name (required)
Mail (will not be published) (required)
Website