Re: Record ID

2001-07-26 Thread Maurice Aubrey
On Thu, Jul 26, 2001 at 10:17:56AM +0200, Peter Wiherkoski wrote: > >Hello, what is the best way to handle record id in MySQL? Has MySQL > >some kind of automatic record id? > > > >if you need a record id which increments automatically, then you can use the > >int types( tiny, medium or int) wit

RE: Record ID

2001-07-26 Thread Peter Wiherkoski
>Hello, what is the best way to handle record id in MySQL? Has MySQL >some kind of automatic record id? >if you need a record id which increments automatically, then you can use the >int types( tiny, medium or int) with the attribute that it be unsigned and >auto_increment like this: >record_id

RE: Record ID

2001-07-26 Thread shane
if you need a record id which increments automatically, then you can use the int types( tiny, medium or int) with the attribute that it be unsigned and auto_increment like this: record_id mediumint unsigned not null auto_increment regards shane -Original Message- From: Peter Wiherkoski [