This article mainly introduces how to create a field that cannot be automatically added in MySQL. This article can solve the problem that causes auto_increament to fail. For more information, see
Cause analysis:
The reason why MySQL cannot create automatically added fields is that several SQL _modes are added in The Server SQL Mode in MySQL 5.0.2, and in The SQL my. two types of SQL-mode are added by default in the INI file. one is STRICT_TRANS_TABLES, which is the mode that causes auto_increament to fail. this SQL _mode is mainly used when a value cannot be inserted into the table, an error is generated instead of a warning and the session is terminated.
Solution:
Delete or comment out SQL _mode. restart mysql.
In my. ini:
The code is as follows:
# Set the SQL mode to strict
SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
Changed:
The code is as follows:
# Set the SQL mode to strict [separator]
# SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
SQL-mode = "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"