primary key

User, date Message
Written by BubikolRamios
8 months ago
Category: General
273 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
8 months ago
3966 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
8 months ago
3966 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.