mysql update where
时间：2021-07-01 10:21:17
帮助过：18人阅读
car_approval a
JOIN car_distribute b
ON a.id
= b.APPROVAL_FOR_CAR_ID
SET a.APPROVAL_STATUS
= ‘approvalStatus-car-complete‘
WHERE
b.ACK_STATUS = ‘CarTaskStatus-EndCarTask‘
and a.APPROVAL_STATUS
<> ‘approvalStatus-car-complete‘;
mysql update where
标签：val _id code mys set update let div stat
