ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: RE : Using a user variable in a request with MySQL
Date Thu, 11 Jun 2009 15:22:11 GMT
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

Mime
View raw message