I'm using the phpMyAdmin interface available at phpwizard.net to manage my MySQL database.
I set a column named 'Home's properties to enum('Out','In','NP') not null. For some reason I am still able to insert a Null value, and there is no error reported like it seems there should be. Even stranger, when I do a select * ... to see the table values, the empty NULL value is displayed, however, when I click on the Edit link, the 'Home' column's select box displays the value 'Out' as the inserted value.
Could someone please tell me what's going on with the enum type and null values?
Thank you,
Dan
I set a column named 'Home's properties to enum('Out','In','NP') not null. For some reason I am still able to insert a Null value, and there is no error reported like it seems there should be. Even stranger, when I do a select * ... to see the table values, the empty NULL value is displayed, however, when I click on the Edit link, the 'Home' column's select box displays the value 'Out' as the inserted value.
Could someone please tell me what's going on with the enum type and null values?
Thank you,
Dan