integer column with auto increments

I have a table like this

count1 value1

1        6
2        4
3        6
4        8

For each new value in the column value1 I insert I want a counter in the count1 column to follow it along.

Does anyone know a simple solution to this.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 08:07:32 CST