MySQL ERROR [select]: SELECT DAYOFMONTH(from_unixtime(postdate)) as day, count(id) as count FROM ng_news WHERE approve = '1' AND postdate >= unix_timestamp('2018-09-01 00:00:00') AND postdate < unix_timestamp(date_add('2018-09-01 00:00:00', interval 1 month)) group by to_days(from_unixtime(postdate))
(1055): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'egf_db.ng_news.postdate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Студентам » Видеоархив

12 марта 2018