Auto-inc column would be the obvious answer, but that's and intrusive answer.
Jerry ----- Original Message ----- From: "Jerry" <[EMAIL PROTECTED]> To: "Luc Foisy" <[EMAIL PROTECTED]> Cc: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 7:10 PM Subject: Re: Row numbers > I still don't understand do you mean the "actual" row number or just a > display number. > > > ----- Original Message ----- > From: "Luc Foisy" <[EMAIL PROTECTED]> > To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> > Sent: Thursday, February 13, 2003 6:59 PM > Subject: RE: Row numbers > > > > 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 > > > > > --------------------------------------------------------------------- > 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
