mysql序号列+自增列update语句

• 添加伪序号列

set @rank= 0;
SELECT a.*,@rank:=@rank + 1 AS rank_no
FROM (
        SELECT *
        FROM pba_audio_item t
        WHERE t.audio_id = '2355'
        order by t.qt_program_id asc
      ) a;

• 自增列update语句

每次update更新一条记录都会执行一次类似 i++的操作

set @rank= 0;update pba_audio_item t set t.orders = @rank:=@rank + 1 
where t.audio_id = '2355' order by t.qt_program_id asc;