Is there a way to increment the value of a sql column without reading it

Question

Hello,

I wanted to know if there is a way I can directly increment the value of a column without reading the current value. something like:

update table `user` set cnt = cnt+1

The above statement gave me a syntax error, but I am sure there has to be something for it.

Thanks

Answer 1

It's just UPDATE, not UPDATE TABLE.