Hi,
On Tue, 2002-03-19 at 16:24, Chuck "PUP" Payne wrote:
> Ok, but that still doesn't any why MySQL is filling the delete slot, I
> understand that I can do any SQL statement to put into the order I want. I
> guess what I am trying to wonder how it place a record into the table, does
> MySQL see
On Tue, Mar 19, 2002 at 01:24:06AM -0500, Chuck PUP Payne wrote:
> Ok, but that still doesn't any why MySQL is filling the delete slot,
> I understand that I can do any SQL statement to put into the order I
> want. I guess what I am trying to wonder how it place a record into
> the table, does My
ugh..I guess that would be a question for the developers:) I don't know the
answer to that question..
Gurhan
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:24 AM
To: Gurhan Ozen; [EMAIL PROTECTED]
Subject: Re: ID ord
e [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 1:17 AM
> To: Gurhan Ozen; mysql lists.mysql.com
> Subject: Re: ID order...
>
>
> Ok, here is a copy of my database and you will see what I am talking
> about...
>
> | 55 | j| programming | http://webd
Hi,
Just add "order by ID" in your query it will give you the results in the way
you'd like...
Gurhan
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:17 AM
To: Gurhan Ozen; mysql lists.mysql.com
Subject: R
ow
> and what you'd like it to return?
> Thanks,
>
> Gurhan
>
>
> -Original Message-
> From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 12:23 AM
> To: mysql lists.mysql.com
> Subject: ID order...
>
-Original Message-
> From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 12:23 AM
> To: mysql lists.mysql.com
> Subject: ID order...
>
>
> Ok, strange question. I have delete some records and I have notice that ID's
> are no lo
f what
the query was returning before the deletion, and what it is returning now
and what you'd like it to return?
Thanks,
Gurhan
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 12:23 AM
To: mysql lists.mysql.com
Subject:
Ok, strange question. I have delete some records and I have notice that ID's
are no longer in order when I do a SQL statement. Why is that? What can I do
put the records back into order?
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.c
