RE: [PHP-DB] mysql and auto_increment

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:josemsala@hotmail.com] Sent: Wednesday, February 20, 2002 9:26 AM To: php-db@lists.php.net 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