Solution for MySql to successfully insert data but report [Err] 1055 error, err1055

Solution for MySql to successfully insert data but report [Err] 1055 error, err1055

1. Problem:

In the past two days, the insert operation is performed. mysql version is 5.7. After the insert operation is successful, an error of [Err] 1055 is reported. The details are as follows:

2. solution:

In linux, run vim TO my. cnf and add the following statement:

SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

Save and exit. Restart mysql.

3. Test

Check whether the problem is solved.

We can see that there is no error.

Summary

The above is a small series of solutions to the MySql data insertion success but the error [Err] 1055 is reported. I hope to help you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!