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) |
|
Valid Values (>= 8.0.1, <= 8.0.4) |
|
Valid Values (8.0.0) |
|