Mysql auto-increment skipping id

Asked Jan 16 '15 at 12:17

Active Jan 16 '15 at 12:44

Viewed 713 times

I have a problem hope anyone here will help me!

auto-increment skipping values on my website (table user).

For Example: id: 30,31,32,33,35

As you can see, auto-increment skip id 34.

My question! is there an way to repair database, in other words, to repair all id from database in order to add id 34.

asked Jan 16 '15 at 12:17

John rocks

3

Nothing to stop you from manually inserting a row with ID 34 ... – Stewart Jan 16 '15 at 12:19
3

This is often caused by a failed insert or deleted record. Just insert with an id of 34 – Fred Jan 16 '15 at 12:20
1

Have a look at http://stackoverflow.com/questions/740358/mysql-reorder-reset-auto-increment-primary-key – Abdul Manaf Jan 16 '15 at 12:22
1

you can manually add it by insert query passing your desired id value. – varsha Jan 16 '15 at 12:23
4

Yes, there is a way. No, you should not care about what are id actual values, if you designed your application correctly. – Alma Do Jan 16 '15 at 12:31
3

There is nothing to "repair" because nothing is broken. – Jan 16 '15 at 12:48
Don't worry about the missing ids. – Strawberry Jan 16 '15 at 12:59
possible duplicate of [Why does MySQL autoincrement increase on failed inserts?](http://stackoverflow.com/questions/2787910/why-does-mysql-autoincrement-increase-on-failed-inserts) – RandomSeed Jan 16 '15 at 14:29

0 Answers0