this is incompatible with sql_mode=only_full_group_by mysql code example

Example 1: GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Example 2: this is incompatible with sql_mode=only_full_group_by

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Example 3: mysql only_full_group_by

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Example 4: this is incompatible with sql_mode=only_full_group_by laravel

'connections' => [
...

    'mysql' => [
    ...
        'strict' => false,
        ...

    ],

]

Tags:

Sql Example