| List: | General Discussion | « Previous MessageNext Message » | |
| From: | crocket | Date: | September 20 2011 5:11am |
| Subject: | auto_increment value increased from 20 to 32 when I inserted a new row. | ||
| View as plain text | |||
Below is the definition of the table with the problem. CREATE TABLE `series` ( `series_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, PRIMARY KEY (`series_id`) ) ENGINE=InnoDB I had 19 rows in series table. And when I tried inserting the 20th row, the auto_increment value suddenly increased from 20 to 32, and the new row has 20 as series_id. This leap seems to happen on every table. What is the cause of the leap in auto_increment?
| Thread | ||
|---|---|---|
| • auto_increment value increased from 20 to 32 when I inserted a new row. | crocket | 20 Sep |
| • Re: auto_increment value increased from 20 to 32 when I inserted a new row. | Johan De Meersman | 20 Sep |
