From: Dan Nelson
Date: August 17 2002 3:38am
Subject: Re: auto increment as primary key
List-Archive: http://lists.mysql.com/mysql/117427
Message-Id: <20020817033818.GG74231@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 16), Fr. Robert Bower said:
> Is it a good idea to use an auto increment field as a primary key in mysql?
> I know in some products like paradox it is a bad idea because of possible
> corruption problems down the road?

If you get corrupt databases, don't blame the primary key.  Blame the
databse software.  :)

You almost always want your autoincrement field to be your primary key,
no matter what database you're using.

-- 
	Dan Nelson
	dnelson@stripped