SELECT列表不在GROUP BY子句中，并且包含未聚合的列…与sql_mode = only_f

我在装有WAMP Server的Windows PC上使用MySQL 5.7.13运行

这是我的问题是执行此查询时

SELECT * FROM tbl_customer_pod_uploads WHERE load_id = '78' AND status = 'Active' GROUP BY proof_type 总是会出现这样的错误

SELECT列表的表达式＃1不在GROUP BY子句中，并且包含未聚合的列'returntr_prod.tbl_customer_pod_uploads.id'，该列在功能上不依赖于GROUP BY子句中的列；这与sql_mode = only_full_group_by不兼容

能否请您告诉我最好的解决方案...

我需要像

+----+---------+---------+---------+----------+-----------+------------+---------------+--------------+------------+--------+---------------------+---------------------+ | id | user_id | load_id | bill_id | latitude | langitude | proof_type | document_type | file_name | is_private | status | createdon | updatedon | +----+---------+---------+---------+----------+-----------+------------+---------------+--------------+------------+--------+---------------------+---------------------+ | 1 | 1 | 78 | 1 | 21.1212 | 21.5454 | 1 | 1 | id_Card.docx | 0 | Active | 2017-01-27 11:30:11 | 2017-01-27 11:30:14 | +----+---------+---------+---------+----------+-----------+------------+---------------+--------------+------------+--------+---------------------+---------------------+