I have such field in the table: optin enum('yes','no') NOT NULL default 'no',
I'm trying to insert into this table and when I don't specify the value the value of the field is empty but not 'no'. Why is that?
Good question. I've also wondered the same thing.
Mysql does have the compile option DDONT_USE_DEFAULT_FIELDS.
So, if your server was compiled using the above option, then default values would not be applied.
Is it possible to change the value in configuration file?
