-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-
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
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
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