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

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/>