First, what do you mean by "regs"? If I understand your question, you want to know if mysql will re-use an old auto_increment value that has been deleted. The answer is yes and no. If you say: DELETE FROM mytable; then the next insertion will cause the auto_increment value to begin at 1
If you say: DELETE FROM mytable WHERE myfield>0 then the next insertion will cause the auto_increment value to begin where the auto_increment left off. -----Original Message----- From: Nautilis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 9:26 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql and auto_increment Hi everyone My question is very simple, so i hope the answer will too :) Well i have an index field in my table which is set as auto_increment. Well question is, it's possible that mysql use values that have alredy been deleted from older regs? Thx in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
