Thread: How to make the key in table increase automatically?

How to make the key in table increase automatically?

From

Mathias Göthberg

Date:

28 August 2000, 05:45:51

How to make the key in a table increase automatically with 1 every time a new row is added?

That is, when I add a new row with all attributes except the primary key, I want the primary key in that row to have a
uniquenumber that is 1 higher than the previous row. 

Mathias

Re: How to make the key in table increase automatically?

From

"Anthony E . Greene"

Date:

28 August 2000, 08:41:13

On 24 Aug 2000 14:24 Mathias Göthberg wrote:
>How to make the key in a table increase automatically with 1 every time a
>new row is added?
>
>That is, when I add a new row with all attributes except the primary key,
I
>want the primary key in that row to have a unique number that is 1 higher
>than the previous row.

Use data type 'serial'.

--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Linux. The choice of a GNU Generation. <http://www.linux.org/>