Oracle/MySQL °ü·Ã °Ô½ÃÆÇ
2016/01/29(21:18)
from
58.125.30.140
ÀÛ¼ºÀÚ :
ÁÖÀÎÀå
Á¶È¸¼ö
: 2441 ,
ÁÙ¼ö
: 2
Re: [MySQL] rownum ±¸ÇöÇϱâ
SELECT @RNUM := @RNUM +1 AS ROWNUM, t.*
FROM (SELECT * FROM persons ORDER BY id) t, (SELECT @RNUM := 0) R
Powered by Kang Jul Ki