Re: auto increment question

[Paul DuBois]

At 15:28 -0800 1/3/03, Kevin wrote:
>Hello,
>
>I have a table with an ID column and a viewed column. I would like the
>viewed column to increment by one each time the row is updated.
>
>Stats
>=======
>ID
>views
>
>is this possible?

Sure.  Since you're updating the row anyway, set the column value to
one more than its current value. :-)

No, it won't happen automatically, which I would guess is what you're
really asking.

>
>-k
>
>sql, query