PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. Returns NULL if X is not in the range -1 to 1, or if X is NULL. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns ...An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
If a table contains no primary key, InnoDB automatically promotes the first UNIQUE NOT NULL index to the primary key. This is not supported for UNIQUE NOT NULL indexes that have functional key parts. A UNIQUE index permits multiple NULL values for ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Returns NULL if any argument is NULL, or if the path argument does not identify a section of the target document. Returns NULL if any argument is NULL or no paths locate a value in the document. row *************************** id: 1 select_type: ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update any TIMESTAMP (but not DATETIME) column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL ... TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
admin_ssl_ca Command-Line Format --admin-ssl-ca=file_name Introduced 8.0.21 System Variable admin_ssl_ca Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value NULL The admin_ssl_ca system variable is like ssl_ca, except that ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
The value is NULL for all data files except for predefined system tablespace data files. A NULL value for a predefined system tablespace data file indicates that a file size limit was not defined explicitly. For NDB: (NDB 8.0.15 and later) For undo ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
The result type depends on whether the function argument values are evaluated as binary strings or numbers: Binary-string evaluation occurs when the argument values have a binary string type, and the argument is not a hexadecimal literal, bit ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. ndbinfo is a database containing ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
The value can be NULL if the row refers to the union result of other rows. If this column is NULL (or undefined in JSON-formatted output), there are no relevant indexes. If key is NULL, MySQL found no index to use for executing the query more ...