How to solve the problem of Incorrect integer value: & # 039; for column & # 039; at row 1
This article focuses on "how to solve the database Incorrect integer value: 'for column' RegNum' at row 1 problem", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to solve the database Incorrect integer value: 'for column' RegNum' at row 1 problem"!
Database version: 5.6.16
Operating system: Red Hat Enterprise Linux Server release 6.3 (Santiago)
Prompt alarm when inserting data:
Mysql > show warnings
+-- +
| | Level | Code | Message | |
+-- +
| | Warning | 1366 | Incorrect integer value:''for column' RegNum' at row 1 | |
| | Warning | 1366 | Incorrect integer value:''for column' Hour' at row 1 | |
+-- +
One of the inserted fields is int, and the inserted null value is''. You should change SQL to null, otherwise the content displayed in the database will be 0 or modify the configuration file and restart:
Sql-mode= "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Change it to sql-mode= "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" and restart mysql.
At this point, I believe you have a deeper understanding of "how to solve the Incorrect integer value: 'for column' RegNum' at row 1 problem of the database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
