Thread: incorrect default value?
View Single Post
  #1  
Old 02-17-2007, 04:28 AM
Hwolfer Hwolfer is offline
Junior Member
  
Join Date: Oct 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Hwolfer is on a distinguished road
Default incorrect default value?
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 --
Reply With Quote
  Webmaster Forums - View Single Post - incorrect default value?
Thread: incorrect default value?
View Single Post
  #1  
Old 02-17-2007, 04:28 AM
Hwolfer Hwolfer is offline
Junior Member
  
Join Date: Oct 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Hwolfer is on a distinguished road
Default incorrect default value?
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 --
Reply With Quote