CODEWITHSUNDEEP
mysqlheroku
Goaler444
Goaler444

Reputation: 2621

Heroku MySQL Auto Increment

I am using ClearDB for a mysql database. I have a table with an auto incremented primary key. The problem is that rather than it incrementing by 1, its incrementing by 10. How can I fix this please?

Also when I tested the db on local host, the incrementation was working correctly.

EDIT: I also tried to use the command: 'SET @@auto_increment_increment=1', but it didnt work. Im not sure if I am doing it right.

Upvotes: 13

Views: 3374

Answers (1)

gary schulte
gary schulte

Reputation: 326

http://www.cleardb.com/developers/help/faq#general_16

auto-increment keys are partitioned between instances to prevent collision.

Upvotes: 12

Related Questions