MySQL sql_mode

January 7, 2017 12:14    mysql


Вместо
SET GLOBAL sql_mode = '';
SET SESSION sql_mode = '';

which mysqld
/usr/local/bin/mysqld --verbose --help | grep -A 1 "Default options"

~/.my.cnf
[mysqld]
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

brew services restart mysql