updating a row to the value plus 1

[pablodelapena]

Is this possible in MySQL? rather than select the row , ++ the variable then update the row can i use a mysql command to do this in one line?

eg: UPDATE table SET col=+1

?

Thanks in advance

[bubblenut]

UPDATE table SET col=col+1 WHERE ...
don't forget your where condition unless you want to update every element in the table.

[pablodelapena]

excellent, yeah i know i was just illustrating. Thanks alot🙂