Keeping count

#1 (**permalink**) 02-28-2008, 07:52 AM

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

#2 (**permalink**) 02-28-2008, 07:53 AM

>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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode