UPDATE `organization_info` SET location_province = NULL, location_city = NULL, location_area = NULL; alter table `organization_info` modify column `location_province` int(2) null comment '所在地-省份', modify column `location_city` int(3) null comment '所在地--市', modify column `location_area` int(4) null comment '所在地--区';