This article mainly introduces the solution for MySql to successfully insert data but report [Err] 1055 error. Friends who need it can refer to it. I hope it can help everyone when you encounter MySql to successfully insert data but report [Err] 1055 error. .
1. Question:
I have been doing insert operations in the past two days. The mysql version is 5.7. Although the insert is successful, an [Err] 1055 error will be reported. The details are as follows:
2. Solution:
In Linux environment, vim to my.cnf and add the following statement:
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
Finally save and exit, restart mysql
3. Test
to see if the problem is solved
Okay See that there is no error anymore.
When you encounter such problems, you can try this method to solve them.
Related recommendations:
What should I do if I encounter Chinese garbled characters when inserting data into MySQL?
php operation mysql insert data
MySQL encoding process of inserting data
The above is the detailed content of Detailed explanation of how to solve the problem of successfully inserting data into MySql but reporting [Err] 1055 error. For more information, please follow other related articles on the PHP Chinese website!