At 03:26 PM 2/14/2002 , you wrote:
>What Rick said is absolutely correct and you probably are obsessing about
>something that doesn't matter. But I would venture you are using an
>auto-number field as the primary key when you could easily change it to a
>function something similar to: set ID = MAX(ID) + 1.
Keith,
I agree with what everyone is saying. But for display purposes,
it would be nice if MySQL could display a row# for the result set. This
could be used to display a line# at the start of each row, like "Select
count, col1, col2 from table1 where ..." and the running count would show
Count Col1 Col2
1 ABC DEF
2 GHI KLM
It would act as sort of a line item# for display purposes only. As everyone
mentioned, it doesn't make any sense to store this number in the table. But
it might come in handy for display purposes.
Brent
>-----Original Message-----
>From: Bryan McCloskey [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, February 14, 2002 4:03 PM
>To: [EMAIL PROTECTED]
>Subject: RE: re-ordering rows
>
>
>You're right, it's not important how the data is
>stored inside the database. I was just hoping that
>there would be a way to set a default order so that I
>wouldn't have to write a cumbersome ORDER BY phrase
>every time I wanted to see the data. I thought that
>perhaps indexes could accomplish this, somehow by
>telling them to re-index the column, but perhaps not.
>
>-b
>
>--- Rick Emery <[EMAIL PROTECTED]> wrote:
> > Why is the internal order important? When
> > SELECTing, the internal order is
> > of no importance to MYSQL. It does not speed-up the
> > query or access. When
> > discussing relational database systems, all that
> > matters is the order of
> > output.
>
>__________________________________________________
>Do You Yahoo!?
>Send FREE Valentine eCards with Yahoo! Greetings!
>http://greetings.yahoo.com
>
>---------------------------------------------------------------------
>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
