Question
Remove only_full_group_by from sql mode
Hello.
I’m trying to remove onlyfullgroupby from sql mode but in the MySQL droplet settings UI
there is no onlyfullgroupby 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?