Question

Remove only_full_group_by from sql mode

Posted April 7, 2020 496 views
MySQL

Hello.
I’m trying to remove onlyfullgroupby from sql mode but in the MySQL droplet settings UI
there is no only
fullgroupby to remove.

Although when I connect to the DB from command line and I run command
SELECT @@sql_mode;

which outputs

REALASFLOAT,PIPESASCONCAT,ANSIQUOTES,IGNORESPACE,ONLYFULLGROUPBY,NOZEROINDATE,NOZERODATE,ERRORFORDIVISIONBYZERO,NOENGINESUBSTITUTION

Which HAS the onlyfullgroup_by !
Any ideas?

1 comment
Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!