mysql中如何将已经获取的数据再进行一次自增id并获取

来源:互联网 发布:linux 高性能c日志库 编辑:程序博客网 时间:2024/03/29 16:20
set @rn=0
select * from (
select @rn:=@rn+1 as rn,mc.* from web_member_character as mc 
ORDER BY $order desc) as tb where uid = $uid 

代码附上~  很好用  利用mysql变量实现
0 0