#1366 MySQL Error resolution appears under apache2.2 php5.3.6 mysql5.5

Environment: Windows 10 10240

PHP Environment

apache2.2 php5.3.6 mysql-5.5.33-winx64

When testing an open source project, there was a

error:1366| | Incorrect integer value: ' for column ' id ' at row 1

Error

Search for solutions Online:

Finally found a way.

Explanation: The ID primary key does not increase automatically in the version after MySQL 5.0, it needs to be assigned.

In the location where the INSERT statement corresponds to the ID, the assignment of NULL will be resolved.

another Netizen's explanation : After analysis MSYQL 5.1 above must assign a value to the field, automatically increase the index field must be assigned null, the previous version can not be assigned to automatically increase.

This article is from the "Lone Boat Night House" blog, please be sure to keep this source http://cysky.blog.51cto.com/211942/1694863

#1366 MySQL Error resolution appears under apache2.2 php5.3.6 mysql5.5