Форум пользователей MySQL

It’s interesting to notice that MySQL didn’t historically conform to SQL standards. As a matter of fact, the engine let you SELECT anything in a query with a GROUP BY . Including non-aggregated columns that do not appear in the GROUP BY and that are not functionally dependent upon the GROUP BY clause:
Luckily, the correct behavior can be enabled by adding a flag (i.e. ONLY_FULL_GROUP_BY) or by using MySQL v5.7.5 or higher. In that case, the query would raise the following error:
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'some_database.films.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Короче надо мне как-то добавить, видимо IF_NULL в SELECT.
Нужно сгруппировать по принципу offer_id и campaign_id, одинаковые, для остальных колонок при группировании игнорируем те строки, что с NULL.

Отредактированно FiMko (25.04.2019 07:10:43)