数据库报错1055 - Expression #1 of SEL

select * from
rs_reservation_info
GROUP BY equipment_no

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lx_lers_dev.rs_reservation_info.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
时间: 0.045s

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

MySQL5.7 group by 必须包含所有select字段

https://www.jb51.net/article/179260.htm

规范sql语句
https://blog.csdn.net/qq_26365837/article/details/88020755?utm_medium=distribute.pc_relevant.none-task-blog-searchFromBaidu-1.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-searchFromBaidu-1.control