How can i solve mysql group by issue?
If we face this kind of problem, Mysql Error 1055. How to solve this
It has two ways and that’s are given below –
Solution 1: Remove ONLY_FULL_GROUP_BY from MySQL console
Answer: First access in our database with MySQL root user. Then run the following query-
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Solution 2: Updating the Mysql query
Answer: To solve this issue permanently we need to update our query.
Update all group column by the primary key of a table and Set multiple groups by if there is any column which is not functionally dependent on columns in GROUP BY clause