MySql successfully inserted data but reported [Err] 1055, err1055

MySql successfully inserted data but reported [Err] 1055, 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.

4. Conclusion

Although it is a small problem, every operation reports an error. It is uncomfortable for people with obsessive-compulsive disorder. This solution is also available on the Internet. Record it here and hope it will help new people.