<update id="updateSortNumber">
SET @i:=0;
UPDATE exam_paper_question SET sort_number = (SELECT (@i:=@i+1)) WHERE paper_id = #
{id} ORDER BY question_type asc
</update>
Mybatis 批量更新数据排序号
最新推荐文章于 2024-04-12 17:23:53 发布