MySQL 8 Administrator???s Guide

Setting the SQL mode

SQL mode can be setup on startup using the --sql-mode="modes" option. The user can also define this option in the option file as sql-mode="modes" . You can define multiple nodes by adding comma separated values. MySQL 8 uses the following modes as default modes: 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 To change mode at runtime, execute the following commands:

SET GLOBAL sql_mode = 'modes';SET SESSION sql_mode = 'modes';

To retrieve the values of both the variables, execute the following commands:

SELECT @@GLOBAL.sql_mode;SELECT @@SESSION.sql_mode;