On Sat, 30 Mar 2002, Mantas Kriauciunas wrote: > I have few users in my small page. And it goes with ID numbers. I > did auto increasement. And i think all the settings are ok. but in > phpMyAdmin it shows ID numbers starting from 5 and i have 10 users > so when i deleted row(user) with ID number 9 i have id number going > like 5 6 7 8 10 .... . So i have like two questions. How to do that > autoincreasement started from 0 and how to do that all id number > where by order without missing some of them when i delete them. Like > how so make that ID number 10 to be number 9 in the list..and all > other number to go down by one. Is there simple way to do it?
If you want flexible, custom sequences, you need something like Oracle! In MySQL what you see is what you get. I think you are probably stuck with that behavior. If you want a truly consecutive and gap-free index you'll have to add another field and maintain it yourself (which will be expensive unless you fastidiously do it whenever you delete a record). miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
