MySQL Server SQL Modes

my.md

MySQL Server SQL Modes

Reference Topic:

Server SQL Modes - https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

Add Mode Settings Via Command line

SET sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";

Add Mode Settings Via Config file

Ubuntu 16.04: /etc/mysql/mysql.conf.d/mysqld.cnf

Strict Mode Enabled

[mysqld]
sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

* Basic Settings

sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";

Remember to restart Mysql Services, and close old command line sessions, in order to see settings taking effect on CMD.

systemctl restart mysql