Recently, I was using the Zend framework and installed a project, and found that

general error: 1366 incorrect integer value: ‘for column’ user appears when registering_ ID ‘at row 1

it’s strange to find that this ID is growing automatically. I found many blogs and finally found out the problem

this kind of problem usually appears on MySQL 5. X. I use MySQL 5.1. The official explanation says: I know that the new version of MySQL has a “bug” in inserting null values. To remove the default check “enable strict SQL mode” when installing mysql, what should we do if we have installed MySQL?The solution is to change the configuration in MySQL and find SQL mode in my.ini

my.ini, The default is: SQL mode = strict_ TRANS_ TABLES,NO_ AUTO_ CREATE_ USER,NO_ ENGINE_ “Substitution”, and modify it to

sql mode = “no”_ AUTO_ CREATE_ USER,NO_ ENGINE_ “Subscription”,

after restarting MySQL, what if it is a virtual host or space. If you can let space business help you change, that is the best, if not, then you can only change the program. Be more standard. Write null instead of null

Similar Posts:

• MYSQL Insert: SQLSTATE[HY000]: General error: 1364 Field ‘xxxxx’ doesn’t have a default value
• Solve the problem of grouping error expression #1 of select list is not in group for MySQL greater than version 5.7
• Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xxxx’ which is not in SELECT list; this is incompatible with DISTINCT
• When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
• [Solved] MYSQL Command gruop by Error: this is incompatible with sql_mode=only_full_group_by
• [Solved] SELECT list is not in GROUP BY clause and contains nonaggregated
• SELECT list is not in GROUP BY clause and contains nonaggregated column
• [Solved] MySQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
• [Solved] MYSQL8 group by Error: Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
• Laravel uses group by to report errors [How to Solve]