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
声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。
- 上一篇: 安装带有Kinfu和GPU并行运算版本的PCL
- 下一篇: jsp网站favicon.ico设置