MySQL auto_increment ??
| From: | Sviss Cobazor | Date: | Wed, 06 Mar 2002 12:34:15 +0000 |
| Subject: | MySQL auto_increment ?? | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-12483@lists.php.net to get a copy of this message | ||
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?