마지막 update ID 구하기

SET @update_id := null;

 

UPDATE

    users

SET

    name = 'value', id = (SELECT @update_id := id)

WHERE

    name = 'blah' LIMIT 1;

 

SELECT @update_id;