mysqlsequelpro

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.

Solution

  • 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.