Re: MySQL AUTO INCREMENT feature

No. You have to empty the table and do a full re-insert. It's like that on purpose. Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: jeremy@nirvani.net http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more Get your own Free, Private email at http://www.smackdown.com/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - At least for the people who send me mail about a new language that they're designing, the general advice is: do it to learn about how to write a compiler. --Dennis Ritchie > I am using the AUTO INCREMENT attribute on one of my cols. I need to know > how I can clean this up. For example, just say I have rows with the > elementID's of 1, 2, 3, 4, 5, 6, 7, 8 and then I delete 3, 6 and 7. > > Is there some command I can call using PHP that will re-eval the elementID > col to reorder them so it became 1, 2, 3, 4, 5 > > Thanks > > Scott. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >