Roger,
Thanks for the additional clarification
Albert
Atlanta
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Albert" <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 8:00 AM
Subject: Re:
ROTECTED]>
Sent: Tuesday, September 02, 2003 8:10 AM
Subject: Re: insert ... select .. order by, problem
> Hi Albert,
> you are not misunderstanding me :-) Tables can indeed not be sorted, it's
> output which gets sorted. The difference is not academic, but important:
It's
>
* Albert
> Stefan,
I'm Roger, but I reply anyway. :)
> Do you imply that tables cannot be sorted desc or asc based on one of the
> columns e.g. a last name? or am I misunderstanding you.
In relational database theory the order of rows within the table is
undefined, i.e. it is up to the server, a
>
> - Original Message -
> From: "Stefan Kuhn" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 02, 2003 6:57 AM
> Subject: Re: insert ... select .. order by, problem
>
> > Hi,
> > I think you can't do this. The
TED]>
Sent: Tuesday, September 02, 2003 6:57 AM
Subject: Re: insert ... select .. order by, problem
> Hi,
> I think you can't do this. There is no order in the table, so there is no
> point in using order by with insert. You always have to do this when
> retrieving the records (the
Hi,
I think you can't do this. There is no order in the table, so there is no
point in using order by with insert. You always have to do this when
retrieving the records (the order you get with select without order by is
accidential).
HTH
Stefan
Am Tuesday 02 September 2003 11:49 schrieb Alejan
Hi Alejondro
> I use ORDER BY, because I want that order in PTemp
> table, so I do not have to order them later (because
> they are retrieved several times later).
If I understand correct ,,,
U can never trust the order ur records get return from DB
(it is indepented of the order u insert record
Hi Stephan,
Let's see the case :
I use ORDER BY, because I want that order in PTemp
table, so I do not have to order them later (because
they are retrieved several times later).
1. Inserting with mysql c.l.i. :
I get the records well sorted : first by a, secondly
by b and finally by c (ascendig
Hi,
well, I'm not totally sure about your question. Which order is reversed ? The
order you get the entries with a select after the insert ? If it is this,
then I think it's not a problem with the insert. The order is then given by
the select, and if no order by is in the select, it is arbitrary