At 15:17 +0530 9/12/05, [EMAIL PROTECTED] wrote:
This is from the docs . "The auto-increment value of a deleted
record will only not be reused until the server is restarted, then
it will be reused. In other words, if you insert 10 rows into an
InnoDB table and then delete them the AUTO_INC
Hello.
> Now if i have records 1 to 10 and i delete some records in between , say, 5,
> 7, 8. Now when i restart my server, will these values of 5, 7 and 8 be
> reused??
No, they won't be reused until your column has values more than 5,7 or 8. The
AUTO_INCREMENT counter initialized to
[EMAIL PROTECTED] wrote:
This is from the docs . "The auto-increment value of a deleted
record will only not be reused until the server is restarted, then it
will be reused. In other words, if you insert 10 rows into an InnoDB
table and then delete them the AUTO_INCREMENT value will stay
