List:General Discussion« Previous MessageNext Message »
From:B. Fongo Date:April 14 2004 3:27pm
Subject:NOT NULL column behaves strangely
View as plain text  
Why does MySQL accept this insert statement with a warning?
 
Insert into Sessions (id) values (20de8376640263673ea03938);
 
Query OK, 1 row affected.
 
I expected a warning because of the Token column shouldn't be NULL! 
 
I have a table with three columns:
 
Id # int not null
Token # char (1) not null
SessTime # Timestamp
 
 


Thread
NOT NULL column behaves strangelyB. Fongo14 Apr
  • Re: NOT NULL column behaves strangelyKeith C. Ivey14 Apr
    • Re: NOT NULL column behaves strangelyRuslan U. Zakirov14 Apr
      • Re: NOT NULL column behaves strangelyMichael Stassen14 Apr
        • AW: NOT NULL column behaves strangelyB. Fongo14 Apr
  • Re: NOT NULL column behaves strangelyMartijn Tonies14 Apr
    • AW: NOT NULL column behaves strangelyB. Fongo14 Apr