MySQL error 1366: 1366 Incorrectintegervalue

MySQL error 1366: 1366Incorrectintegervalue must be recorded. It took me a whole day and finally found that it was only an SQL error that had nothing to do with others, programmers with a wealth of experience in such problems should first think of the mysql problem, but generally people will think that the php source code has gone wrong.

MySQL error 1366: 1366 Incorrect integer value must be recorded. It took me a whole day and finally found that it was only an SQL error that had nothing to do with others, programmers with a wealth of experience in such problems should first think of the mysql problem, but generally people will think that the php source code has gone wrong.

MySQL error 1366: 1366 Incorrect integer value

This must be recorded. It took me a whole day, and I finally found that it was only an SQL error that had nothing to do with others, programmers with a wealth of experience on such issues should first think of the mysql issue, but most people will think that the php source code has gone wrong. This is a kind of thinking inertia, php code is the most commonly used, so it is difficult to think of it as a MySQL problem. Although it has already been obvious, when an error code is prompted after execution, "1366 Incorrect integer value: ''for column 'configuration _ group_id 'at row 1
In:
[Insert into nfj_configuration_group VALUES ('', 'easy populate', 'config options for Easy populate', '1', '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
".

1366 error is a MySQL configuration problem. You only need to find my. in the "ini" file and find the SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, Tables" sentence, delete {STRICT_TRANS_TABLES,} before the double quotation marks, and change it to SQL-mode = "NO_AUTO_CREATE_USER, manual ", restart mysql. The former is very strict and does not allow null values to be inserted into the database. Therefore, there will be the single quotation mark next to the Value. Do not read the error message. Otherwise, you will be able to take a detour...