Hello. I’m trying to remove only_full_group_by from sql mode but in the MySQL droplet settings UI there is no only_full_group_by to remove.
Although when I connect to the DB from command line and I run command SELECT @@sql_mode;
Which HAS the only_full_group_by ! Any ideas?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!