incorrect default value?

[Hwolfer]

Hi all of you,
MySQL version is 4.1.20 and I created a table i.e.
create table tbl_nm (record-id int(11),............,publish int(1) default '1' NOT NULL,....);
The default value for the field publish is 1, but on inserting values, it shows '0' whereas the default value is 1.
So, how to correct this thing? Please advise.
Thank you so much! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Beau]

You should have "DEFAULT 1" not "DEFAULT '1'". The first assigns a default of the numeric value 1, the second assigns a default value of the string "1"; Also, your data type is INT, so assign it a valid integer value. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --