Mysql versions later than 5.0.17 deal with ''and null _ MySQL

Mysql versions later than 5.0.17

Mysql versions later than 5.0.17 deal with ''and null

After MySQL is upgraded to 5.0.17, execute the SQL statement

Insert INTO 'table name' () VALUES ();

Error:

#1264-Out of range value for column ''at row 1

Cause: The new MySQL version strictly checks fields. (Auto_increment is used)

Solution:

Modify my. ini and set

SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Change

SQL-mode = "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION ".

Restart MySQL.

In Linux, change/etc/my. cnf, and there may be no SQL-mode,

You can add SQL-mode = "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION" under [mysqld"

Use mysql> SELECT @ SQL _mode; to query the current mode.

BitsCN.com