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