DuBois
Cc: MySQL List
Subject: Re: Can you skip ORDER BY & get rows back in inserted order ?
>> Is there some way that I can avoid doing an ORDER BY and get my
>> rows back ordered by album_id, rank they way I inserted them ?
>No. That is the nature of relational databases
At 9:52 -0800 3/5/02, Sam Iam wrote:
> >> Is there some way that I can avoid doing an ORDER BY and get my
> >> rows back ordered by album_id, rank they way I inserted them ?
>
> >No. That is the nature of relational databases.
>
>Is this because the index cache in ram may not be loaded in orde
>> Is there some way that I can avoid doing an ORDER BY and get my
>> rows back ordered by album_id, rank they way I inserted them ?
>No. That is the nature of relational databases.
Is this because the index cache in ram may not be loaded in order ?
> You might want to consider adding an A
At 8:16 -0800 3/5/02, Sam Lam wrote:
>I have a table like so :
>
>CREATE TABLE album_rank(
> album_id INT NOT NULL,
> rank INT NOT NULL,
> KEY(album_id)
>)
>
>I want to query on the album_id & get the results ordered by rank
>but I want to avoid doing an ORDER BY in the query be