MySQL select list is not in

Time：2020-12-30

SELECT list is not inGROUP BY clause and contains nonaggregated column
MySQL strict mode mainly uses the following scenarios

  • Inserting null values into not null fields is not supported
  • Insertion of ‘0’ values for self growing fields is not supported
  • Text field with default value is not supported

We can close it when we don’t need it. We can edit it in laravel database.php , turn off strict mode, you can edit when you don’t use the frame my.ini
Add a line to [mysqld]

[mysqld]
sql-mode=""

Restart MySQL and close it

This work adoptsCC agreementReprint must indicate the author and the link of this article

Tags: , , , ,

Recommended Today

SAP Spartacus Definition of Done

SAP Spartacus Definition of Done) Coding guidelines The Spartacus team adopted the following set of rules to maintain the readability and maintainability of Spartacus code. As a contributor, we ask you to follow these rules (even if you find them violated somewhere). When files always don’t follow these rules and following them will make the […]