You should use what you referred to as an insertion counter field. I'd call it a "id" field that uses auto_increment. It's very useful to use this and by definition it enables you to retrieve the data in the order that it was inserted.
> ----- Original Message ----- > From: "Murad Nayal" <[EMAIL PROTECTED]> > To: "MySQL List" <[EMAIL PROTECTED]> > Sent: Saturday, August 02, 2003 2:40 AM > Subject: retrieving rows by insertion order > > > > > > > > Hello, > > > > I vaguely remember reading in the manual that the order of the retrieved > > rows in a response to a select statement is unpredictable (unless you > > use an order by clause). this possibly depends on the indices set up for > > the table and/or used in constructing the result etc. is this accurate? > > if so is there any way to insure that rows retrieved are returning in > > the order by were inserted in, say other than ordering by some > > 'insertion counter' (such a counter is of no use otherwise in my > > application!). > > > > thanks for the help. > > > > -- > > Murad Nayal M.D. Ph.D. > > Department of Biochemistry and Molecular Biophysics > > College of Physicians and Surgeons of Columbia University > > 630 West 168th Street. New York, NY 10032 > > Tel: 212-305-6884 Fax: 212-305-6926 > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]