MySQL with error 1264 : Out of range value.........



One of my staff found some strange error

1264 Out of range value adjusted for column 'ID' at row 1
"ID" is auto increment field. This should insert if we have not define a field record id...

The problem from Guaranteeing Data Integrity with MySQL 5.0 !

you can remove a SQL-MODE parameter - "STRICT_TRANS_TABLES" in my.ini file

change
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"





Links
Guaranteeing Data Integrity with MySQL 5.0
5.2.5. The Server SQL Mode
11.1.4. Data Type Default Values

Comments

Popular posts from this blog

3G Bandwidth bonding solutions

docker - could not read CA certificate