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?

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!