Is there a way to increment the value of a sql column without reading it
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
It's just UPDATE
, not UPDATE TABLE
.
精彩评论