Re: MySQL concept question

2002-04-12 Thread Christopher Thompson
-Original Message- > From: Gregory Junker [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 11, 2002 5:23 PM > To: MySQL > Subject: RE: MySQL concept question > > > if you are interested in selecting records in the order in which they > were inserted, apply an auto-

RE: MySQL concept question

2002-04-12 Thread Thi Cao
Can I hide the auto_increment field? -Original Message- From: Gregory Junker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 5:23 PM To: MySQL Subject: RE: MySQL concept question if you are interested in selecting records in the order in which they were inserted, apply an

RE: MySQL concept question

2002-04-11 Thread Gregory Junker
if you are interested in selecting records in the order in which they were inserted, apply an auto-increment/identity field to your table schema and when you select, use ORDER BY on that field. This is the only guaranteed way to retrieve records in the order in which they were inserted. > -Or

Re: MySQL concept question

2002-04-11 Thread Christopher Thompson
On Thursday 11 April 2002 4:09 pm, Thi Cao wrote: > All, > > When I insert records into a database, the records will be inserted in the > order that I have them listed in my insert statement. So my question is, > will the MySQL database always return the records in the order of insertion > when I