The current server SQL mode, which can be set dynamically. For details, see Section 5.1.11, “Server SQL Modes” . Note MySQL installation programs may configure the SQL mode during the installation process. If the SQL mode differs from the default or from what you expect, check for a setting in an option file that the server reads at startup. If enabled (the default), diagnostics of  Note  level increment  warning_count  and the server records them. If disabled,  Note  diagnostics do not increment  warning_count  and the server does not record them.  mysqldump  includes output to disable this variable so that reloading the dump file does not produce warnings for events that do not affect the integrity of the reload operation. 887 System Variable sql_notes Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value ON • sql_notes Server System Variables IGNORE_SPACE NO_AUTO_VALUE_ON_ZERO NO_BACKSLASH_ESCAPES NO_DIR_IN_CREATE NO_ENGINE_SUBSTITUTION NO_UNSIGNED_SUBTRACTION NO_ZERO_DATE NO_ZERO_IN_DATE ONLY_FULL_GROUP_BY PAD_CHAR_TO_FULL_LENGTH PIPES_AS_CONCAT REAL_AS_FLOAT STRICT_ALL_TABLES STRICT_TRANS_TABLES TIME_TRUNCATE_FRACTIONAL