更新查询id

SET @update_id := 0;
UPDATE some_table SET row = 'value', id = (SELECT @update_id := id)
WHERE some_other_row = 'blah' LIMIT 1; 
SELECT @update_id;
posted @ 2022-02-17 17:36  wyz_1  阅读(24)  评论(0编辑  收藏  举报