There is no relevant data or use to this number. It is the row number of the returned result set, purely for display.
I was hoping there was some kind of function just to drop a number in there, regarless of any data that is stored in the table or regardless of the order the resultset appears. > -----Original Message----- > From: Jerry [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 1:48 PM > To: Luc Foisy > Subject: Re: Row numbers > > > Have to have one in the row and select that along with the > query, if your > going to use it for some other sql command it probally should > be in the > table already > > ----- Original Message ----- > From: "Luc Foisy" <[EMAIL PROTECTED]> > To: "Jerry" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 5:59 PM > Subject: RE: Row numbers > > > > No language, just straight mysql > > > > > -----Original Message----- > > > From: Jerry [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, February 13, 2003 12:53 PM > > > To: Luc Foisy > > > Subject: Re: Row numbers > > > > > > > > > using what language ? or the mysql client ? > > > > > > ----- Original Message ----- > > > From: "Luc Foisy" <[EMAIL PROTECTED]> > > > To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> > > > Sent: Thursday, February 13, 2003 5:48 PM > > > Subject: Row numbers > > > > > > > > > > > > > > Is there a way to get a row number returned with any > select query? > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php