//值为null都改成1 UPDATE tenant_employees set insure = 0 WHERE insure is null; //设置表默认值为1 alter table `tenant_employees` MODIFY column `insure` INT(1) not null default 0;