select tt.rowno
from( select (@rownum:=@rownum+1) as rowno, t.id
from news t ,(select (@rownum :=0) ) b
where .....) tt
where tt.id=503
赞
踩
转载于:https://www.cnblogs.com/yulouchun/p/8358004.html
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。