Keeping count

[kev]

Hi,

I am trying to keep count of an item.

Table: id | item | count

I want to increment count by 1 when item is accessed using one SQL
statement. Is this possible?

Thank you in advance for your help.

Kev

[Gordon Burditt]

>I am trying to keep count of an item.

>
>Table: id | item | count
>
>I want to increment count by 1 when item is accessed using one SQL
>statement. Is this possible?

UPDATE tablefoo set count = count + 1 where id = 666;

Gordon L. Burditt