ProblemYou want to avoid resequencing a column, but you're running out of room for new sequence numbers. SolutionCheck whether you can make the column UNSIGNED , or change the column to use a larger integer type. DiscussionResequencing an AUTO_INCREMENT column changes the contents of potentially every row in the table. It's often possible to avoid this by extending the range of the column, which changes the table's structure rather than its contents:
Section 11.2 includes a table that shows the ranges for each integer data type. You might find it helpful in assessing which type to use. |