MySQL兑现rownum

2012-07-04

MySQL实现rownumSELECT @rownum:@rownum+1 AS rownum, frutas.*FROM (SELECT @rownum:0) r, frutas

MySQL实现rownum
SELECT @rownum:=@rownum+1 AS rownum, frutas.*
FROM (SELECT @rownum:=0) r, frutas;