Shulou(Shulou.com)06/01 Report--

Editor to share with you the solution to the success of MySql insertion data but reported [Err] 1055 error, I hope you will learn a lot after reading this article, let's discuss it together!

1. Question:

These two days to do insert operation, the mysql version is 5.7 after inserting successfully, but will report a [Err] 1055 error. The details are as follows:

two。 Solution:

In linux environment, add the following statement from vim to my.cnf:

Sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Finally, save and exit and restart mysql

3. test

See if it can be solved.

You can see that there is no error.

After reading this article, I believe you have a certain understanding of the method of solving the successful MySql insertion data but reporting [Err] 1055 error. Want to know more about it, welcome to follow the industry information channel, thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.