select * from (
select
@rownum := @rownum+1 as rownum,
goods_id
from table_goods, (select @rownum:=0) t where test_id = 10) m
where m.goods_id = 57806
转载于:https://www.cnblogs.com/yangcclg/p/5328868.html
select * from (
select
@rownum := @rownum+1 as rownum,
goods_id
from table_goods, (select @rownum:=0) t where test_id = 10) m
where m.goods_id = 57806
转载于:https://www.cnblogs.com/yangcclg/p/5328868.html