[email protected]
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
De : Larry Meadors [[email protected]]
Date d'envoi : jeudi 11 juin 2009 15:58
À : [email protected]
Objet : Re: Using a user variable in a request with MySQL
On Thu, Jun 11, 2009 at 7:42 AM, Gilles
SCHLIENGER wrote:
>
> SET @NUM=0;
> SELECT (@NUM:=...@num+1), JET
On Thu, Jun 11, 2009 at 7:42 AM, Gilles
SCHLIENGER wrote:
>
> SET @NUM=0;
> SELECT (@NUM:=...@num+1), JET_ID FROM JETON
>WHERE JET_FK_ABO_ID = 3;
>
Sorry, I'm not really up on mysql - what is this supposed to do?
Larry
Hello,
I'm using iBATIS (2.3.4.726) integrated with Spring, MySQL 5.0 (iBATOR with
Eclipse) and I love it.
I'm faced with a specific need where I have to use a MySQL user variable.
I need to execute the following (simplified) request from my java code:
SET @NUM=0;
SELECT (@NUM:=...@num+1), JET
