카테고리 없음
Implement Oracle's rownum using mysql
[czar]
2008. 4. 10. 10:56
SELECT @rownum:=@rownum+1 rownum, t.*
FROM (SELECT @rownum:=0) r, mytable t;
FROM (SELECT @rownum:=0) r, mytable t;