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/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/server-system-variables.html
admin_ssl_ca Command-Line Format --admin-ssl-ca=file_name 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 it applies to the ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/nested-join-optimization.html
In some of the following examples, NULL where a table name appears means a row in which NULL is used for each column of that table. For example, t1||t2||NULL indicates a row constructed by concatenating the columns of rows t1 and t2, and NULL for ...
https://dev.mysql.com/doc/refman/9.7/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 *************************** 8. ndbinfo is a database containing ...