Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Disable Strict mode in Sequel Pro

How to disable mysql strict mode in Sequel Pro on Mac? I got this error sql_mode = only_full_group_by. Been trying to find the solution, but nothing helps.

like image 335
Syamim Hazmi Avatar asked Mar 08 '17 03:03

Syamim Hazmi


People also ask

How do I turn off strict mode in phpmyadmin?

You can change the value of sql_mode to NO_ENGINE_SUBSTITUTION to completely disable strict mode, but you may want to look up each mode that is configured before disabling it. If sql_mode isn't set, you can add it under the [mysqld] heading, then save the file, and restart MySQL.

What is strict SQL mode?

Strict SQL Mode. Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE . A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range.


1 Answers

You might get an error referring to only_full_group_by when you're running MySQL 5.6-compatible SQL code on a MySQL 5.7 database.

To temporarily make the MySQL 5.7 database behave like a MySQL 5.6 database, you will have to run this query first:

SET SESSION sql_mode="NO_ENGINE_SUBSTITUTION";

enter image description here

This works in Sequel Pro, Sequel Ace, and other database managers.

like image 115
Pepijn Olivier Avatar answered Oct 06 '22 19:10

Pepijn Olivier