Re: choosing primary keys

2001-07-04 Thread Steve Edberg
At 1:45 PM +0100 7/4/01, matthew yee-king wrote: >Hello >sorry if this is old hat... > >i am trying to figure out a way to assign primary keys to my database tables. >I have previously used ints with auto_increment but i am wondering >what happens when you reach the highest number possible for an

choosing primary keys

2001-07-04 Thread matthew yee-king
Hello sorry if this is old hat... i am trying to figure out a way to assign primary keys to my database tables. I have previously used ints with auto_increment but i am wondering what happens when you reach the highest number possible for an int... is there some way of 'reclaiming' primary key