Failed to read auto-increment value from storage engine 诡异的mysql自增无效问题
来源:互联网 发布:计算机二级vb培训 编辑:程序博客网 时间:2024/05/16 16:05
今天遇到的,
ALTER TABLE `gsmc` CHANGE `id` `id` BIGINT(19) NOT NULL AUTO_INCREMENT COMMENT "id备注" ;
执行此语法后
插入记录提示Failed to read auto-increment value from storage engine
因为很多表对此表有外键引用,想把自增删掉重建,无法操作,查了很多资料
最后执行 ALTER TABLE gsmc ORDER BY `id` ;
后就可以再正常插入记录了
0 0
- Failed to read auto-increment value from storage engine 诡异的mysql自增无效问题
- MYSQL-Failed to read auto-increment value from storage engine
- Mysql错误:Failed to read auto-increment value from storage engine Query的解决方法
- Failed to read auto-increment value from storage engine
- Failed to read auto-increment value from storage engine
- Failed to read auto-increment value from storage engine
- Failed to read auto-increment value from the storage engine in MySQL
- Failed to read auto-increment value from storage engine错误的处理方法
- Failed to read auto-increment value from storage engine错误的处理方法
- Failed to read auto-increment value from storage engine错误的处理方法
- Failed to read auto-increment value from storage engine错误的处理方法
- auto-increment 主键自增
- Mysql报Got error 28 from storage engine错误问题
- mysql的“Got error 28 from storage engine”错误
- 从mysql 的Got error 28 from storage engine说起
- mysql的“Got error 28 from storage engine”错误
- mysql的“Got error 28 from storage engine”错误
- MySQL中设置Auto Increment的值
- 【杭电1009】FatMouse' Trade
- java学习深度优先算法(未测试)
- CALayerInvalidGeometry', reason: 'CALayer position contains NaN: [160 nan]
- 禁止进入activity自动弹出键盘
- 路由器和交换机的区别
- Failed to read auto-increment value from storage engine 诡异的mysql自增无效问题
- Maven 项目构建问题汇总
- Java拼音拆分算法 (未测试)
- Eclipse下Target识别不出来引起的DDMS中Emulator Control显示灰色(Android SDK和ADT版本不兼容问题导致的)
- Android学习笔记--什么是回调
- 1040. 有几个PAT(25)-PAT乙级真题
- Android代码的组织结构
- AFHTTPRequestOperationManager找不到的原因
- C语言中位移问题