Re: [google-cloud-sql-discuss] Anyway to disable only_full_group_by on 5.7

Hi,

Now you can Google Cloud Platform Console and then go to your instance detail page then you will see  above configuration -> Edit Configuration(in last after loading) press that edit and Then you will see option for "Add database flags" (4th option ) press on that so you will see "database flags"-----> select item from dropdown (if you can't see then press + add item) and select < sql_mode > and you will see another dropdown -> Select < STRICT_TRANS_TABLES > ... Then HIT "SAVE " button and it will automatic restart your SQL instance and after that fire your QUERY again you will see your result...

Regards
Darshit.

On Wednesday, August 3, 2016 at 10:49:06 PM UTC+5:30, Hajar Homayouni wrote:

Hi,

How can I disable Strict mode in Cloud sql?

On Friday, June 3, 2016 at 10:34:35 AM UTC-6, David Newgas wrote:

Hi,

ONLY_FULL_GROUP_BY isn't actually a database flag, it is one of the possible parameters of the sql_mode database flag. sql_mode is one of the supported flags in Cloud SQL, which means you can change it by editing the instance properties. In order to remove ONLY_FULL_GROUP_BY but leave the other default modes you would need to set sql_mode to STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE(etc). Unfortunately it seems that our validation only allows you to set one mode. This is a bug, which I am reporting now.

In the mean time the best workaround is to use SET SESSION sql_mode='...' at the start of each session to remove the mode.

David

On Fri, Jun 3, 2016 at 6:29 AM, Matt Bourne <matt...@gmail.com> wrote:

It seems like there is no super access and although you can add flags there appears no way to remove default flags like only_full_group_by

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/b977f133-5127-4a54-9fa6-cdc7be6ac465%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9d6ed035-0887-497b-a3cb-bdfd93902a71%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.