Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

entering a default value of 0 with not null for an int column

Apr 18, 2009, 7:33 AM
chmodphil
New User (3 posts)
Apr 18, 2009, 7:33 AM
Views: 13649
Shortcut
Quote Reply
entering a default value of 0 with not null for an int column
Having problem with int column since upgrading to mysql 5.0 when setting 'not null' and default 0 (zero) the column comes back not null but without a default....when entered as sql in SQL Monitor it works fine???

Any help appreciated.

Cheers
Subject Author Views Date
Thread entering a default value of 0 with not null for an int column chmodphil 13649 Apr 18, 2009, 7:33 AM
Thread Re: [chmodphil] entering a default value of 0 with not null for an int column 		brewt 13264 Apr 18, 2009, 3:40 PM
Post Re: [brewt] entering a default value of 0 with not null for an int column 		chmodphil 13242 Apr 18, 2009, 4:32 PM
Thread Re: [brewt] entering a default value of 0 with not null for an int column 		brewt 13191 Apr 24, 2009, 8:15 PM
Post Re: [brewt] entering a default value of 0 with not null for an int column 		chmodphil 13110 May 8, 2009, 6:37 AM