问题描述
我有一个 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 无法从存储引擎读取自动增量值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！