SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ibaobaby_v4.ula.AREA' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by select uld.id, uld.name, uld.type, phone, gender, language, hospitals, IFNULL(image,'') as image, did, area, street, apt,city, state, zip, YEAR(CURDATE())-birthyear as age, licensenumber,YEAR(CURDATE())-YEAR(gradyear)-1 as workage from u_ll_doctor_address ula left join u_ll_doctor uld on uld.id = ula.did where status='A' group by id limit 0, 20; 出错啦。