mysql - How to set the group by statement in sequel Pro to default to the first record of the group

Question

select age,money from t1.gz group by age;
发现报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.gz.money' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Answer 1

Your current sql_mode does not allow non-aggregated fields to appear in the form of non-aggregated functions. Just change sql_mode, or min(id) takes the first row of records and then connects to the original table to get the results you want