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 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 | linux | http://lwn.net | Linux Weekly News | | 58 | l | linux | http://www.linuxstart.com | Linux Start | | 74 | b | beos | http://www.beosonline.com/index.php?seite=english | BeOS Online <German Site> | | 75 | b | beos | http://www.blueos.free.fr | BlueOS | | 62 | s | graphics | http://www.steeldolphin.com | Steel Dolphin Creative | | 63 | w | graphics | http://www.wacom.com/tips | Wacom Photoshop Tips... | | 64 | d | graphics | http://www.dvpa.org | Digital Video Prof. Assoc. | | 73 | o | beos | http://open-beos.sourceforge.net | Open BeOS | | 66 | p | graphics | http://www.photoshopcertification.com | NAPP's Practice Certification Exam | | 67 | d | graphics | http://deezin.com/ | The Graphic Design Resource Center | | 68 | p | graphics | http://www.photoshopseminars.com | Adobe Photoshop Seminar Tour... | | 69 | p | graphics | http://www.photoshopcafe.com | Photoshop Cafe | I deleted 59, 60, 61, 65. MySQL place 74 into 59 slot, 75 into 60, and 73 into 65. The SQL state I did was.... Select * from table_name; Just a simple command. So again why is it filling the deleted slot? 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 > --------------------------------------------------------------------- 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