alter table user modify column passworddate date not null default '1900-01-01', modify column birthday_search date not null default '1900-01-01'; update user set birthday_search = '1901-01-01' where DATE_FORMAT(birthday_search,'%Y-%m-%d') = '0000-00-00';