mysql SELECT 自增数显示
时间：2009-03-28 来源：Digico
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<='$gbludate' group by passport order by clnumber desc
相关阅读 更多 +
