Martin, Shawn, you are correct. An oversight on my part...this is why I still follow this list, I am always able to learn something and never cease to be humbled.
Ed -----Original Message----- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 8:01 AM To: emierzwa; mysql@lists.mysql.com Subject: Re: why NOT NULL in PRIMARY key?? > Not every DBMS... > > MSSQL: > Create Unique Index > Microsoft(r) SQL Server(tm) checks for duplicate values when the index > is created (if data already exists) and checks each time data is added > with an INSERT or UPDATE statement. If duplicate key values exist, the > CREATE INDEX statement is canceled and an error message giving the first > duplicate is returned. Multiple NULL values are considered duplicates > when UNIQUE index is created. > > > SYBASE: > Create Unique Index > Prohibits duplicate index (also called key) values. The system checks > for duplicate key values when the index is created (if data already > exists), and checks each time data is added with an insert or update. If > there is a duplicate key value or if more than one row contains a null > value, the command is aborted and an error message giving the duplicate > is printed. An unique index is not a primary key constraint. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]