Thanks Larry, As far as I know, this is the standard workaround in MySQL to get the ROW_NUM of the resultset.
For example, this would return: 1,190 2,560 3,989 I actually need this to retrieve that number in a more complex query with joins Thanks Gilles ________________________________________ 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<[email protected]> 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
