"A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL will declare them so implicitly (and silently). A table can have only one PRIMARY KEY. If you don't have a PRIMARY KEY and an application asks for the PRIMARY KEY in your tables, MySQL returns the first UNIQUE index that has no NULL columns as the PRIMARY KEY." (MySQL Manual | 14.2.6 CREATE TABLE Syntax)
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html --- Cemal Dalar <[EMAIL PROTECTED]> wrote: > Is this normal to have a index like below.. As I > know there is no need to > have "KEY" and "UNIQUE" for a PRIMARY KEY > > > PRIMARY KEY (`urun_id`), > UNIQUE KEY `UC_urun_id` (`urun_id`), > KEY `IDX_urun_urun_id` (`urun_id`), > KEY `ktgr` (`ktgr`) > ) TYPE=MyISAM > > > > Best Regards, > Cemal Dalar a.k.a Jimmy > System Administrator & Web Developer > http://www.dalar.net > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
