List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 8 2011 5:43am
Subject:Re: Data missing after field optimization
View as plain text  
----- Original Message -----
> From: sono-io@stripped
> 
> Yes.  That's all I did.

If that's all you did, you indeed 'removed the default NULL' but did not specify another
default. Hence, if you don't explicitly specify a value in your insert statement, the
insert can not happen as the server doesn't know what to put there and is explicitly
disallowed from leaving the value empty.

Where did you find the advice about setting columns NOT NULL? You really shouldn't take
everything you read on the internet as truth :-)

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
Data missing after field optimizationsono-io7 Jun
  • Re: Data missing after field optimizationJohan De Meersman7 Jun
    • Re: Data missing after field optimizationsono-io7 Jun
      • Re: Data missing after field optimizationRik Wasmus7 Jun
      • Re: Data missing after field optimizationJohan De Meersman8 Jun
        • Re: Data missing after field optimizationsono-io9 Jun
          • RE: Data missing after field optimizationJerry Schwartz9 Jun
        • Re: Data missing after field optimizationsono-io14 Jun
          • Re: Data missing after field optimizationJohan De Meersman14 Jun