MySQL Forums
Forum List  »  MySQL Workbench

fluctuations in generation of primary key auto increment value.
Posted by: Ashok kumar
Date: October 11, 2014 01:53AM

Dear friends,

I was just try to Insert some columns in mysql table.table consists primary key with auto increment (seed value=1).

So Intitially table is :

id name
---------------
1 williams
2 andrew

But After i inserted,the table is :

id name
---------------
1 williams
2 andrew
4 methew
5 ram

So i am not aware why some fluctuations happening in autoincrement value.Why the id 3 was ignored.
So please clarify my doubt.

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
fluctuations in generation of primary key auto increment value.
1305
October 11, 2014 01:53AM


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.