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

This article will explain in detail the solution of mysql5.7 error 1055 for you. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Mysql5.7 error 1055 solution: first find and open the my.cnf configuration file; then delete the "only_full_group_by" item, or open the mysql command line and execute the command "select @ @ sql_mode".

Mysql5.7 reported error 1055

What's new in MySQL5.7 group by, error 1055

Mysql5.6 was originally used for development in the project. After switching to 5.7.7, I suddenly found that some of the original sql runs reported errors, error code 1055, error messages and "only_full_group_by" in sql_mode. I read the reasons on the Internet. It is said that the only_full_group_by mode in mysql5.7 is enabled by default. There are roughly two solutions:

One: use the any_value () function on fields that do not need group by in sql query statements

Of course, this is not suitable for projects that have developed a lot of functions. After all, it is necessary to modify the original sql.

Second: modify the configuration file of my.cnf (my.ini under windows) and delete the item only_full_group_by

The mysql of our project is installed on ubuntu. Find this file and open it. There is no sql_mode configuration item inside. Even if you want to delete it, you can't delete it.

Of course, there is another way. Open the mysql command line and execute the command.

Select @ @ sql_mode

In this way, you can find out the value of sql_mode, copy this value, and add configuration items to my.cnf (delete the only_full_group_by option from the query value, and copy everything else):

Sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Remember to open the comment if the line [mysqld] is commented out. Then restart the mysql service

Note: use the command

Set sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

This allows you to modify configuration items in one session, which are not valid in other sessions.

On the mysql5.7 error 1055 solution to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.