Cannot set initial value for AUTO_INCREMENT in MySQL

Question

First, I create column img_ids, which I want to increment later on, with initial value 393.

Next step, I do the following:

Alter table img_ids_for_media modify image_id int(11) AUTO_INCREMENT PRIMARY KEY

This gives me simple incrementation 1,2,3...

After this I try:

 Alter table img_ids_for_media  AUTO_INCREMENT = 393

This query passes, but does not do anything at all. I still have 1,2,3, not

393,393,394

What can I do with this?

Shadow · Accepted Answer · 2018-02-22 12:35:24Z

2

The problem is that changing the auto_increment value for a table sets the next auto_increment value to be used, it does not affect existing values within the field - rightly so.

What you can do is update the existing auto_increment values by adding 392 to them (image_id=image_id+392).

Then make sure you set the next auto_increment value to max(image_id)+1.

answered Feb 22, 2018 at 12:35

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammad Anas · Accepted Answer · 2018-02-22 12:45:32Z

0

It is already answered under How to set initial value and auto increment in MySQL?

Check this link

How to set initial value and auto increment in MySQL?

answered Feb 22, 2018 at 12:45

Mohammad Anas

3283 silver badges6 bronze badges

1 Comment

Shadow Over a year ago

That's what exactly the OP did and ended up having this question.

Collectives™ on Stack Overflow

Cannot set initial value for AUTO_INCREMENT in MySQL

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related