CODEWITHSUNDEEP
mysqlauto-increment
Nathan Verni
Nathan Verni

Reputation:

MySQL table incrementing by 10 for some reason

The id field in a mysql table is incrementing by 10 (11, 21, 31) for some reason. Here is the table definition:

CREATE TABLE `clients` (
  `id` int(11) NOT NULL auto_increment,
  `first_name` varchar(255) default NULL,
  `last_name` varchar(255) default NULL,
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

If I do a simple insert statement in SQL the next ID will be 41.

Upvotes: 6

Views: 1160

Answers (1)

brian-brazil
brian-brazil

Reputation: 34152

You have auto_increment_increment set to 10, change it back to 1.

Upvotes: 9

Related Questions