MYSQL 的SQL_MODE – 工作生活心情记忆

发表于2019-10-242019-10-25 作者 wind

Property	Value
Command-Line Format	`--sql-mode=name`
System Variable	`sql_mode`
Scope	Global, Session
Dynamic	Yes
`SET_VAR` Hint Applies	Yes
Type	Set
Default Value (>= 8.0.11)	`ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_ENGINE_SUBSTITUTION`
Default Value (<= 8.0.4)	`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`
Valid Values (>= 8.0.11)	`ALLOW_INVALID_DATES` `ANSI_QUOTES` `ERROR_FOR_DIVISION_BY_ZERO` `HIGH_NOT_PRECEDENCE` `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`
Valid Values (>= 8.0.1, <= 8.0.4)	`ALLOW_INVALID_DATES` `ANSI_QUOTES` `ERROR_FOR_DIVISION_BY_ZERO` `HIGH_NOT_PRECEDENCE` `IGNORE_SPACE` `NO_AUTO_CREATE_USER` `NO_AUTO_VALUE_ON_ZERO` `NO_BACKSLASH_ESCAPES` `NO_DIR_IN_CREATE` `NO_ENGINE_SUBSTITUTION` `NO_FIELD_OPTIONS` `NO_KEY_OPTIONS` `NO_TABLE_OPTIONS` `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`
Valid Values (8.0.0)	`ALLOW_INVALID_DATES` `ANSI_QUOTES` `ERROR_FOR_DIVISION_BY_ZERO` `HIGH_NOT_PRECEDENCE` `IGNORE_SPACE` `NO_AUTO_CREATE_USER` `NO_AUTO_VALUE_ON_ZERO` `NO_BACKSLASH_ESCAPES` `NO_DIR_IN_CREATE` `NO_ENGINE_SUBSTITUTION` `NO_FIELD_OPTIONS` `NO_KEY_OPTIONS` `NO_TABLE_OPTIONS` `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`