Resolve MySQL 5.0 cannot use auto add field problem

Problem: MySQL 5.0 cannot use automatic increment fields.

Specific reasons:

The reason for this is that in the MySQL5.0.2 version of the Server SQL Mode, several new sql_mode are added, and in the SQL My.ini file Sql-mode The default increase of two of them, one is Strict_trans_tables Is the mode that causes Auto_increament to fail, and this sql_mode is primarily used when a value cannot be inserted into a table, resulting in an error instead of a warning and terminating the session.

Solution:

Delete this sql_mode. Restart MySQL.

To My.ini in the following:

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_create_USER,NO_ENGINE_SUBSTITUTION"
改为：
# 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"