how to make the auto_increment in mysql consecutive

Question

0.00/5 (No votes)

See more:

Hello

I have tried to alter a table to add a index column by using auto increment like this;

SQL

alter table donordetails add SlNo int not null auto_increment first ,add unique key(SlNo);

It is working, but the incrementing of the value is not consecutive, some times random value is coming, so what to do ?

any methode something like identity(1,1) in mssql

Regards
Ginnas

Posted 25-Mar-13 4:38am

ginnas

Updated 25-Mar-13 4:47am

Kenneth Haugland

v2

Add a Solution

Comments

PIEBALDconsult 25-Mar-13 11:00am

auto_increment is evil, don't use it.

CHill60 25-Mar-13 12:26pm

What would you suggest as an alternative?

ginnas 25-Mar-13 11:10am

thanks

but tell me the proper one to use in mysql please

Thanks
Ginnas

CHill60 25-Mar-13 12:19pm

Under what circumstances does random value get assigned ... do you have any zeroes in s1No? Are you inserting then deleting lots of rows? Finally do you still get the problem if you define s1No as unsigned or bigint?

ginnas 25-Mar-13 22:49pm

thanks

i will try to clear the situation to you, what is happening means while i am insering a value continously the auto increment column should be increment consecutivly but sometimes it is not consecutive like this suppose ....401,402,403,406 so inbetween some valuelike 404,405 is missing thats the problem

Thanks
Ginnas

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Style-7 · Answer 1 · 2013-03-25T07:50:00

Solution 1

Try

SQL

PRIMARY KEY (`SlNo`)

Posted 25-Mar-13 7:50am

Style-7

Comments

ginnas 25-Mar-13 22:44pm

thanks

but in my table already one primary key is assigned
then what to do?

Thanks

Ginnas