[Phpmyadmin-devel] frustrating problem with NULL values in number fields
When you are creating a new field and you want the default to be NULL, the query is getting passed through as ... default 'NULL' ... but since the quotes are around NULL, it is interpreted as the string NULL so the default becomes 0...maybe we could add a little checkbox for null, so it would be like Default ------- -- | | or | |null ------- -- what do you think? Dan Allen
Dan, this is Feature request #442855 : null field values: checkbox Marc Dan Allen a écrit :
When you are creating a new field and you want the default to be NULL, the query is getting passed through as
... default 'NULL' ...
but since the quotes are around NULL, it is interpreted as the string NULL so the default becomes 0...maybe we could add a little checkbox for null, so it would be like
Default ------- -- | | or | |null ------- --
what do you think?
Dan Allen
participants (2)
-
Dan Allen -
Marc Delisle