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
