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
Ok, here is a copy of my database and you will see what I am talking
about...
| 55 | j| programming | http://webdeveloper.earthweb.com/pagedev/webjs
| Javascripts.com|
| 56 | h| webdesign | http://www.htmlgoodies.com
| HTML Goodies |
| 57 | l
Maybe. Just I have delete let say ID 63, 64 and when I added 74,75. They are
place into the slot where 63, 64 were. So I read this in the ID list 61,62,
74, 75, 66, 67... I am trying to understand why it's placing 74 and 75 in
the slots that were deleted. Is there a re-index command that will plac
Yes it is a strange question.. MySQL result sets are in the order you asked
in the query. IF you would like the result set to be in order by a field
called ID then just add "order by ID" at the end of your query..
Is this what you were asking? If not , can you give more insights of what
the query
