Issue with Modifying auto_increment Value

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 修改auto_increment值问题

| username: TiDBer_QHSxuEa1

After using ALTER TABLE table_name AUTO_INCREMENT = xxxxxx, querying the auto-increment value becomes 1. However, in actual tests, the inserted value is the adjusted auto-increment value, but the correct auto_increment value cannot be obtained in the statistics information, and using ANALYZE TABLE does not work either.

image
image1224×239 7.4 KB

2
| username: Billmay表妹 | Original post link

The image you provided is not accessible. Please provide the text you need translated.

3
| username: zhanggame1 | Original post link

A small issue, add the force parameter

alter table table_name force auto_increment = xxxxxx