哈哈

摘要： Mysql5.7中子查询时order by与group by合用无效，在实践中发现order by的子查询语句未生效，此处记录相应的解决办法。 阅读全文

摘要： 使用select * from 表 group by 字段 时报错：1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'haha_db.staff.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 阅读全文