Solve the problem that MySQL 5.0 cannot use auto-add fields

Specific reasons:

The cause is that several SQL _modes are added to The Server SQL Mode in MySQL 5.0.2, and. 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 this SQL _mode. Restart mysql.

In my. ini:

# Set the SQL mode to strict

SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Changed:

# Set the SQL mode to strict

# SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

SQL-mode = "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"