distal-attribute
distal-attribute
distal-attribute
distal-attribute

primary key

User, date Message
Written by BubikolRamios
2 years ago
Category: General
326 posts since Thu, 14 Jan 10
http://dev.mysql.com/doc/refman/5.1/en/create-table.html:


A PRIMARY KEY is a unique index where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL declares them so implicitly (and silently).



Some kind of warning, mybe, would be appropriate if one creates a primary key with nullable columns.

Even if you have a checkmark on 'allow null' on field inside index, it will create primery key without any warning.
Written by ansgar
2 years ago
4784 posts since Fri, 07 Apr 06
Can confirm that. r4191 removes the checkable checkbox for primary key columns, and forces the column to be NOT NULL.
Written by ansgar
2 years ago
4784 posts since Fri, 07 Apr 06
As an addition, r4192 displays not applicable table attributes with a disabled checkbox, where Heidi displayed no checkbox at all previously. Makes it more clear for the user I think:

 

Please login to leave a reply, or register at first.