Is it possible to increase an int field by one in one mysql query?

Question

PHP

Hello!
It became interesting, is it possible to increase an int field by one through one mysql query?
That is, there is a num attribute.
We write some query specifying a record (let's say 'WHERE id=1') and change the value of num to num+1 . Otherwise
, we did select first and then update
. Maybe there is a simpler way?

Answer 1

SET `int_field_name` = `int_field_name` + 1 ?