MySql inserts data successfully but reports [Err] 1055 error solution

1. Question:

I have been doing insert operations these days. The MySQL version is 5.7. Although the insert is successful, an error [Err] 1055 is reported. The details are as follows:

2.Solution:

In the Linux environment, go to my.cnf with vim and add the following statement:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Finally save and exit, restart mysql

3. Testing

See if it is solved

You can see that there is no error.

Summarize

The above is the solution that I introduced to you when MySql successfully inserts data but reports [Err] 1055 error. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!