List:General Discussion« Previous MessageNext Message »
From:Hunter Hillegas Date:October 5 1999 10:09pm
Subject:Re: Outputting Selects in Random Order
View as plain text  
When I search for random there are no matches... Maybe someone has a message
that they can forward to me?
----- Original Message -----
From: "Thimble Smith" <tim@stripped>
To: "Hunter Hillegas" <hunter@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, October 05, 1999 3:00 PM
Subject: Re: Outputting Selects in Random Order


> At 14:50, 19991005, Hunter Hillegas wrote:
> >Is there any way from something like 'SELECT * FROM RECORDS' would output
> >the results in a random order, not by insertion order?
>
> Check the mailing list for "random", there's been several discussions on
> it.
>
> A select does *not* happen in insertion order by default.  Please do not
> depend on that in your programs, because they will certainly break.  You
> can not count on any order back from a SELECT unless you specify one with
> an ORDER BY clause!
>
> Tim
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread15224@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>

Thread
A question about indexesMoz5 Oct
  • Re: A question about indexesBob Kline5 Oct
    • Outputting Selects in Random OrderHunter Hillegas5 Oct
      • Re: Outputting Selects in Random OrderThimble Smith6 Oct
      • Re: Outputting Selects in Random OrderBob Kline6 Oct
        • Re: Outputting Selects in Random OrderScott Hess6 Oct
          • Re: Outputting Selects in Random OrderThimble Smith6 Oct
          • Re: Outputting Selects in Random OrderBob Kline6 Oct
            • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
              • Re: Outputting Selects in Random OrderBob Kline6 Oct
                • Re: Outputting Selects in Random OrderMartin Ramsch7 Oct
    • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
Re: A question about indexesMark Papadakis5 Oct
  • Re: A question about indexesBob Kline6 Oct