牛骨文教育服务平台(让学习变的简单)
博文笔记

mysql update by query

创建时间:2018-01-24 投稿人: 浏览次数:203
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
声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。