BRIEF INTRODUCTION
- 行業動態 -
操作數據庫失敗Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'henanzhenyu.sf_content.inputtime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
sql:select from_unixtime(inputtime,'%Y-%m') as year,from_unixtime(inputtime,'%d') as day,inputtime from sf_content where catid=39 group by day having count(day) < 4 order by inputtime desc limit 0,4