DEV Community

Ashwani Singh
Ashwani Singh

Posted on

Let’s solve the error of GROUP BY clause and contains nonaggregated column in MySQL

Image description



SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

jennapederson profile image

What I learned while building my first game

Jenna Pederson -

thepracticaldev profile image

Top 7 Featured DEV Posts of the Week

dev.to staff -

sunilkumrdash profile image

9 open-source AI coding tools that every developer should know 🎯

Sunil Kumar Dash -

jwilliamsr profile image

AI Security: How to Protect Your Projects with Hardened ModelKits

Jesse Williams -