AW: NOT NULL column behaves strangely

2004-04-14 Thread B. Fongo
Ja! Most RDBMS don't use default values for NOT NULL columns. Rather they alarm if a statement renders such fields NULL. I do agree with Michael. Mysql went a different way in this regard, in that it assigns default values... It only warns if one tries to explicitly enter "NULL" in NOT NULL colu

AW: NOT NULL column behaves strangely

2004-04-14 Thread B. Fongo
What is NOT NULL good for, if Mysql will insert a default value? I thought Mysql should warn: "Column can't be NULL" if no value is provided. Thanks anyway Babs -Ursprüngliche Nachricht- Von: Martijn Tonies [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 14. April 2004 17:39 An: B. Fon