After chopping hands, the fraud call came before the express delivery was received. How to improve the privacy and security of e-commerce>>>
When inserting data, the system prompts “failed to read auto increment value from storage engine” error. After consulting the data, the solution is as follows:
1) remove the auto increment option of auto increment field of data table and save it
2) reset this field to auto increment field
Problem solving
Reference: http://liguoliang.com/2010/mysql1467-failed-to-read-auto-increment-value-from-storage-engine/
Similar Posts:
- MySQL timestamp set default value error Invalid default value reason and solution
- SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”
- mysql: [Err] 1075 – Incorrect table definition; there can be only one auto column and it must be d…
- [Solved] MySQL query reports an error: Legal mix of settlements
- MYSQL Insert: SQLSTATE[HY000]: General error: 1364 Field ‘xxxxx’ doesn’t have a default value
- When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
- MYSQL ERROR 1005 (HY000): Can’t create table [How to Solve]
- Error in modifying data element data type [How to Solve]
- [Solved] MySQL uses the workbench tool, and the table status is read only
- Mysqldump error: tab (ErrCode:13-Permission denied) [How to Solve]