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 place them into the right order.
Chuck on 3/19/02 1:00 AM, Gurhan Ozen at [EMAIL PROTECTED] wrote: > 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 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. 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.com | > | [EMAIL PROTECTED] | > ---------------------------- > > BeOS, Macintosh 68K, Classic, and OS X, Linux Support. > Web Design you can afford. > > "Never be bullied into silence. Never allow yourself to be made a victim. > Accept no one's definition of your life; define yourself."- Harvey Fierstein > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
