[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [Phpgroupware-developers] phpgwapi/setup scripts .. can table have a
RE: [Phpgroupware-developers] phpgwapi/setup scripts .. can table have a two field pk with both fields as nullable?
Thu, 14 Aug 2003 15:12:36 +0000
I would think that null WOULD be a distinct value for one record
Anyway .. discussion closed, code will use "not null" field types
Kai Hofmann (address@hidden) wrote:
>> In MySql Primary Keys are not allowed to be nullable. What
>> about useing
>> an odinary value of 0 instead of null. This would work.
>A primary key is distinct - so it can not be null in ANY database!
>Using 0 as a value for it works for excatly one entry.
>So its not possible to have more than one column of a primary key with the
>***** Open Source und Linux im professionellen Einsatz *****
>** komplexe Mailserver, Groupware, Office: sprechen Sie uns an **
>Dipl.-Inform. Kai Hofmann Team Softwarelösungen
>pro|business AG, EXPO Plaza 1 (Deutscher Pavillon), 30539 Hannover
>E-Mail: address@hidden, Tel.: 0511/60066-332, Fax: -355
>Phpgroupware-developers mailing list
* This is where my witty signature line would be if I bothered to edit this
line :) *
|[Prev in Thread]
||[Next in Thread]|
- RE: [Phpgroupware-developers] phpgwapi/setup scripts .. can table have a two field pk with both fields as nullable?,
Brian Johnson <=