RE: [PHP-DB] mysql and auto_increment

2002-02-20 Thread Rick Emery
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

RE: [PHP-DB] mysql and auto_increment

2002-02-20 Thread Gurhan Ozen
Yes you sure can,.. When you insert a row just use one of the older values that no longer exists on the table.. Alternatively, you can insert a blank value, mysql will automatically set it to the next value after the highest one in the table and then you can update it to one of the older values.