Hi.
On Wed, Apr 18, 2001 at 04:17:45PM +0800, [EMAIL PROTECTED] wrote:
> Siggy...
>
> thanks for the past reply...
>
> but i i dont want to SORT the record in ASCENDING or DESCENDING order
> just a plain invert...
That doesn't make really sense. According to the SQL specification,
without ORDER BY the records are retrieved in an undefined order.
Inverting an undefined order makes the records still being in an
undefined order. You see my point?
It seems that you are relying on the internal order of MySQL, which is
considered a *Bad Thing*. MySQL is free to change this order at will,
any time.
According to the specification, if you leave out the ORDER BY clause,
generally spoken, an RDBMS is even allowed to return the records in
different order each time you run the same query! And there is no
guarantee that the next MySQL version won't do exactly that (even if
it is very, very unlikely).
So you may want to describe to us what you want to archieve (why do
you want that inverting) and maybe someone will come up with a
solution.
Bye,
Benjamin.
> --------------------------
>
> use the ORDER BY clause with the SELECT
>
> SELECT * FROM table ORDERBY fieldname ASC
> (or replace ASC with DESC for descending order)
>
>
> Siggy
>
> ----- Original Message -----
> From: "Michael M. Ocana" <[EMAIL PROTECTED]>
> To: "Mysql Lists" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 18, 2001 2:55 PM
> Subject: inverse function
>
>
> > Subject: inverse function (database,sql,query)
> >
> >
> > hello anybody knows how to invert selected records?
> >
---------------------------------------------------------------------
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
