At 0:44 +0530 2/26/02, Chetan Lavti wrote: >hi, >I creating a table where I am using one field as Auto Increment. I want >to know two things or rather I want to do to thinks for the same column > >1. When I am inserting the values and the Query fails, the increment >should not took place and >2. When I delete a particular row from the table there should not be any >gap in the auto increment sequence. > >Is it possible..??
No, in both cases. There's an exception for your first question, which is that if the query fails because it's syntactically invalid, the counter will not increment. But if it fails after MySQL has incremented the counter and then something goes wrong, the counter won't decrement. > >I am not much enthusiastic about the second one because I don't think >that I will use it. > >Anyone who can help me out for this.?? > >Thanks and regards, >Cretan Latvia --------------------------------------------------------------------- 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
