MySQL Forums
Forum List  »  InnoDB

Auto Increment field
Posted by: Tarik Alkathiri
Date: January 18, 2009 03:40AM

Dear Experts;

I have created a table with ID as auto increment field, when i issue an insert command it auto increment the ID correct, but when I issue an insert command with value in the ID (like I have the last ID no is 10) and issue an insert command with ID 50 it takes it and it saved the record with the ID 50.
As far as I know the auto increment should not allow you to put any number for inserting new record, or other wise it is not an auto increment any more.
Can any one please explain to me this problem.
Thank you very much for help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Auto Increment field
7325
January 18, 2009 03:40AM


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.