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 |
|
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: ID order...
Ok, strange question
]]
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 longer in order when I do a SQL statement. Why is that? What can I do
put the records back into order
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...
Ok, strange question. I have delete some records and I have notice that ID's
are no longer
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: Re: ID order...
Ok, here
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://webdeveloper.earthweb.com/pagedev/webjs
| Javascripts.com|
| 56 | h| webdesign | http
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 order...
Ok
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 MySQL
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 that