A "selective" table update ?

[4rxsid]

Hi all,

not sure how to word this..but here goes:

i have a table with a column of data type smallint.
how could i increase that number that's stored in the smallint by 1...only when certain pages or conditions are meet, in other words...an autoincrement is not wanted here because i don't want to increase that # by one each and every time the table is updated (for other columns).

is it possible to do an UPDATE (with a ++ on the column) on the table w/o first doing a SELECT to get the present number?

thanks!

[Aeiri]

Yes, but not quite a ++ operator like in PHP or JS.

You can use:

update table set column=column+1

Hope this helps.

[4rxsid]

very kewl Aeiri...i didn't realize it would be so simple!

thanks.