MySQL ID

From: Date: Sat, 30 Mar 2002 08:26:40 +0000
Subject: MySQL ID
Groups: php.general 
Request: Send a blank email to php-general+get-90751@lists.php.net to get a copy of this message
Hey php-general@lists.php.net, 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? P.S i am so sorry that my english is weak. I am just learning ESL ir highschool :).... Thanks for helping everybody :------------------------------: Have A Nice Day! Mantas Kriauciunas A.k.A mNTKz Contacts: Mantuks@attbi.com Http://mntkz-hata.visiems.lt

« previous php.general (#90751) next »