UPDATE zf_member d INNER JOIN
(SELECT B.id FROM
zf_user
A
LEFT JOIN zf_member
B
ON A
.id
=B
.user_id
WHERE A
.user_group_id
IN (‘2’,‘4’,‘5’,‘6’,‘7’,‘8’,‘10’,‘11’) AND B
.mt
= ‘1’
AND B.is_signing = 0 AND B.assess !=3 AND B.assess !=4
AND A
.created
<= ‘2019-10-01 00:00:00’ ORDER BY A
.id
DESC) c
ON c.id = d.id
SET d.lawyerid = 0,d.assigntime=NOW(),d.recover_status = 1
批量修改数据表字段
最新推荐文章于 2022-09-21 18:15:00 发布