Page 1 of 1

error for blank value

Posted: Wed Mar 29, 2006 10:48 pm
by s.dot
when trying to insert into a table, i get this error

Code: Select all

Field 'description' doesn't have a default value
I don't want it have a default value =/ I've never encountered this error before.

Posted: Wed Mar 29, 2006 10:55 pm
by feyd
sounds like you specified the field "NOT NULL", and you aren't setting a value in the insertion.

Posted: Wed Mar 29, 2006 11:00 pm
by s.dot
Hmm. I've never had this error before. Perhaps it's because I'm using a newer version of MySQL. I've actually never set a field to NULL. If I do this, can I still UPDATE the table later and add information to the field?

*reads up on null* :)

Posted: Wed Mar 29, 2006 11:15 pm
by s.dot
seems like that did the trick.
i just don't feel comfortable setting a field to a null value =/
i don't really know why either ;)