mysql update by query
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
声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。
- 上一篇:没有了
- 下一篇:没有了