select * from (select *, @row_number := @row_number+1 AS row_number from cms_abc,(select @row_number:=0) as t where album_id=6 order by sort desc,id asc) as t where t.id=107;
在select 中声明变量
最新推荐文章于 2022-04-14 18:21:47 发布
select * from (select *, @row_number := @row_number+1 AS row_number from cms_abc,(select @row_number:=0) as t where album_id=6 order by sort desc,id asc) as t where t.id=107;