PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. and these potential issues to consider: If you make enumeration values that look like ...See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated 8.0.34 ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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 ...