1.为表添加排序字段,默认值0 2.语句 UPDATE t_ued_icon_package SET sequence = (SELECT se + 1 FROM (SELECT MAX(sequence) AS se FROM t_ued_icon_package) IP) WHERE id = 3 ; *需要为中间表起别名 sql语句意思是每次将置顶项的排序字段设为sequence列最大值+1 再使用order by sequence 排序即可