MySQL Forums
Forum List  »  Perl

Re: Duplicate entry in auto-increment field
Posted by: Bob Field
Date: February 08, 2007 09:06AM

The only time MySQL should assign a sequential value to a column is if the column is NULL. If you explicitly specify a value, it will either insert that value, or return an error. Specifying a value for the auto_increment column skips the auto_increment process, and it behaves like a normal column for that statement.

Options: ReplyQuote


Subject
Written By
Posted
Re: Duplicate entry in auto-increment field
February 08, 2007 09:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.