PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/error-log-rule-based-filtering.html
For readability and portability, symbolic values are preferable (where applicable) to numeric values. Error codes can be specified in numeric form or as the corresponding error symbol. Symbolic names can be specified as quoted strings for comparison ... The log_filter_dragnet log filter component enables log filtering based on user-defined ...
https://dev.mysql.com/doc/refman/9.7/en/hexadecimal-literals.html
In numeric contexts, MySQL treats a hexadecimal literal like a BIGINT UNSIGNED (64-bit unsigned integer). To ensure numeric treatment of a hexadecimal literal, use it in numeric context. Due to the difference in result types, the displayed values ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
The following comparison operators and functions are not yet supported with JSON values: BETWEEN IN() GREATEST() LEAST() A workaround for the comparison operators and functions just listed is to cast JSON values to a native MySQL numeric or string ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
The VECTOR, DECIMAL, NUMERIC, and BIT types are all supported in MySQL 9.7. Attempting to cast a BigInt or String having a non-numeric value to MySQL FLOAT raises an invalid type conversion error. MySQL decimal types (DECIMAL and NUMERIC) are ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-priority-based-filtering.html
A numeric code may be specified with or without the MY- prefix. Examples of permitted code formats: ER_SERVER_SHUTDOWN_COMPLETE MY-000031 000031 MY-31 31 For readability and portability, symbolic values are preferable to numeric values. Although ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
For the FLOAT and DECIMAL columns, the string-to-number conversion considers the entire string a valid numeric value. This is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. Instead, the ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/9.7/en/load-data.html
For example, a value such as 'x' for a numeric column results in an error, not conversion to 0. Examples: A value such as 'x' for a numeric column results in conversion to 0. An out-of-range numeric or temporal value is clipped to the closest ...The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
(See Section 8.2.16, “Server Handling of Expired Passwords”.) --connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 0 The number of seconds before connection timeout. --max-allowed-packet=value ... mysql ...
https://dev.mysql.com/doc/refman/9.7/en/server-system-variables.html
completion_type Command-Line Format --completion-type=# System Variable completion_type Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value NO_CHAIN Valid Values NO_CHAINCHAINRELEASE012 The transaction completion ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/9.7/en/set.html
MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. If you retrieve a SET value in a numeric context, the value retrieved has bits set corresponding to the set members that make up ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...