Detailed explanation of how to solve the problem of successfully inserting data into MySql but reporting [Err] 1055 error

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!