mysql 无法从存储引擎读取自动增量值

mysql Failed to read auto-increment value from storage engine(mysql 无法从存储引擎读取自动增量值)

问题描述

我有一个 id 字段作为自动增量的 mysql 表.

I am having mysql table with one id field as auto-increment .

当我向表中插入值时出现错误

When I insert values to the table am getting error as

1467 - 无法从存储引擎读取自动增量值

1467 - Failed to read auto-increment value from storage engine

还有 show table status 告诉我自动递增的字段有

Also the show table status shows me that the field with auto increment has

18446744073709551615 作为 Auto_increment 值.

18446744073709551615 as Auto_increment value.

有什么问题可以帮助我....

What would be the issue can any one help me ....?

推荐答案

问题可能是:将 18446744073709551615 转换为十六进制，你会发现
$FFFF-FFFF-FFFF-FFFF.
如果您的字段是未签名的 64 位，则会达到其限制.

Problem could absolutely be that: convert 18446744073709551615 to hex and you'll find
$FFFF-FFFF-FFFF-FFFF.
If your field is an unsigned 64bit you reach its limit.

这篇关于mysql 无法从存储引擎读取自动增量值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！