Thread

1. How to make the key in table increase automatically?

   Mathias Göthberg <s97math@student.informatik.gu.se> — 2000-08-24T18:24:32Z

   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.
   
   Mathias
   
   
   
   
   
   
   

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

   Anthony E . Greene <agreene@pobox.com> — 2000-08-28T09:41:01Z

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