实现置顶功能

一、将表中字段最大值加1赋值，然后使用order by ordinal desc 

<update id="updateGasArticleOrdinal" parameterType="Long">
     UPDATE gas_article SET ordinal = (SELECT ordi+1 FROM(SELECT MAX(ordinal) AS ordi FROM gas_article) IP )WHERE article_id=#{articleId}
</update>

二、可以将表字段最小值赋值，然后使用 order by ordinal asc ，update_time desc

<update id="updateGasArticleOrdinal" parameterType="Long">
     UPDATE gas_article SET ordinal = (SELECT ordi FROM(SELECT MIN(ordinal) AS ordi FROM gas_article) IP )WHERE article_id=#{articleId}
</update>