I stated to implement something like Oracle's ROWNUM ... but noone's listening ... therefore I build an UDF ...
> -----Ursprüngliche Nachricht----- > Von: Luc Foisy [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 13. Februar 2003 20:00 > An: MYSQL-List (E-mail) > Betreff: 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
