2017-06-10.sql 360 B

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