update Supplier set isManufacturer = 1 ,isSupplier = 0 where rentTousse = '生产厂家'; update Supplier set isManufacturer = 0 ,isSupplier = 1 where rentTousse = '供货单位'; update Supplier set isManufacturer = 0 ,isSupplier = 0 where rentTousse not in ( '供货单位', '生产厂家');