If the colum is set to unique, it will fill in 2. If not, it'll automatically goto 4 (or vice versa if I'm mistaken).
> -----Original Message----- > From: Jack [mailto:[EMAIL PROTECTED]] > Sent: November 23, 2001 7:46 AM > To: Mysql List > Subject: Question on auto_increment > > > I knew that if record at the Largest number of index being delete, the > number will be reused, but i have a question: > what happen if i delete the record which the index number is between the > largest and the smallest, let say "i have 3 records within my > table, by some > reason, i got to delete the record in index 2 which is between 1 > and 3, then > will it leave a index gap between or it will move the record of index 3 up > to index 2??? > > Thx > > Jack > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php