SELECT s.`id`, (@i:=@i+1) as i FROM store s,(select @i:=0) as x
ORDER BY i DESC
select (@i:=@i+1) as i,table_name.* from table_name,(select @i:=0) as it order by
例子:
select passport,count(*) as clnumber,'20090301',(@i:=@i+1) as i,'1' from table,(select @i:=0) as it where insert_date>='$gbludate' and insert_date