MySQL table: BIT(1) not null default b'1', however, always default to '0' -
this how created table:
create table `item_spa_cust` ( `id` int(10) not null auto_increment, `spa_id` int(10) null default null, `type` varchar(20) not null collate 'latin1_swedish_ci', `is_valid` bit(1) not null default b'1', `company_name` varchar(50) null default null collate 'latin1_swedish_ci', `custno` varchar(6) null default null collate 'latin1_swedish_ci', primary key (`id`), index `fk_item_spa_cust_item_spa` (`spa_id`), constraint `fk_item_spa_cust_item_spa` foreign key (`spa_id`) references `item_spa` (`id`)) ;
i expecting is_valid
field default '1' set it, however, it's defaulting '0'.
i'm confused this, please help.
you should use 1
, rather b'1'
that being said, in sqlfiddle, works expected.
if you're inserting , looking default value, should not specify in insert query.
Comments
Post a Comment