UPDATE
resume_dis dis,
(SELECT
oper_user_id,seeker_id,resume_id
FROM
resume_dis
WHERE
resume_id = '8fPw2'
AND seeker_id = '1516711287136_8fPw2'
and resume_state!='60009'
ORDER BY
create_time
LIMIT 0,1) d
SET
dis.resume_state='',
dis.update_time=NOW()
WHERE dis.resume_id = d.resume_id
AND dis.seeker_id = d.seeker_id
AND dis.oper_user_id = d.oper_user_id
mysql update by query
最新推荐文章于 2024-06-11 14:47:26 发布