create table customer_history(id int not null primary key,mid char(5) not null,nam varchar(20),birth date,sex char(1) default 0 check (sex in (0,1)),updated datetime)
你这什么数据库，mysql？
