MySQL Forums
Forum List  »  Quality Assurance

Problems with non-null columns (5.0.51a-community-nt)
Posted by: Kurt Erickson
Date: March 30, 2008 03:16AM

Alright, I recently upgraded my database to 5.0.51, it was previously 4.14.44 (I can't recall what release it was after 4.14...).

My problem is that, creating a table with columns that are set to "NOT NULL" are not generating a default value for the column.
In 4.14, for example, if I set an INT data-type column and set it to "NOT NULL", it would automatically fill the default value with 0.
I'm not sure if this is expected or not, I think it might have just been a problem when I installed it.
If not, is there a setting that'll make it do this on it's own?

Options: ReplyQuote

Written By
Problems with non-null columns (5.0.51a-community-nt)
March 30, 2008 03:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.