-java@ibatis.apache.org
Objet : Re: RE : Using a user variable in a request with MySQL
I see, try this:
SELECT (@rownum:=...@rownum+1), JET_ID
FROM JETON, (SELECT @rownum:=0) r
WHERE JET_FK_ABO_ID = 3;
Found it here:
http://jimlife.wordpress.com/2008/09/09/displaying-row-number-rownum-in-mysql/
It
I see, try this:
SELECT (@rownum:=...@rownum+1), JET_ID
FROM JETON, (SELECT @rownum:=0) r
WHERE JET_FK_ABO_ID = 3;
Found it here:
http://jimlife.wordpress.com/2008/09/09/displaying-row-number-rownum-in-mysql/
It might work, I don't have a mysql install handy to try it on. :-/
Larry
