Re: my sql database query retrieval order

2001-06-22 Thread Benjamin Pflugmann
Hi. There may be some internal order, but according to the SQL specification, you may not rely on it. The order of records of a query without ORDER BY is undefined on purpose. Bye, Benjamin. On Fri, Jun 22, 2001 at 01:43:33PM +0100, [EMAIL PROTECTED] wrote: > Hi, > I wonder to know if

my sql database query retrieval order

2001-06-22 Thread VVM Ravikumar Sarma Chengalvala
Hi, I wonder to know if mysql follows any order in retrieving the data from a table.i.e Is it based on ascending row order or descending row order. --Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or