update driver_online
set vRemainCapacity= case when (vRemainCapacity>0) and ((vRemainCapacity-0.5) >0) then vRemainCapacity-0.5 else 0 end
where driverId = 'DR120161118100001
update driver_online
set vRemainCapacity= case when (vRemainCapacity>0) and ((vRemainCapacity-0.5) >0) then vRemainCapacity-0.5 else 0 end
where driverId = 'DR120161118100001