Hi NG. Now I've read page up and page down in the MySQL online manual about how to use the auto_increment. But I didn't find anywhere how to reuse a deleted id created by auto_increment.
Say I have a table [users] with 4 columns: | ID | name | username | password | ID is an auto_increment value. If I insert 3 users they will get ID = 1, 2 and 3 assignet. Now I want to delete user with ID = 2. Now I create a new user, he will get ID = 4. How can i reuse the ID 2 for creation of new users? Another thing: If ID is INT(3), what will happen when I insert user no. 1000? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
