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
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
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 records
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
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 order you get with select without order
[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. 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
* 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, and
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
not the table which gets an order, but the output. Take
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: insert ... select .. order by, problem
* Albert