Database is mysql8
the self-increment id checked out by the following statement and the actual self-increment id of the table will not,
select auto_increment from information_schema.tables where table_schema="test" and table_name="product"; the engine of the table is MyISAM
try to fix
alter table product auto_increment=23; modification has no effect
repair, and the optimized table cannot solve the problem.
the same is true of changing the engine of the table to innodb. After analyzing the table, the self-increasing information in the information_ schema.tables table can return to normal