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/mysql-cluster-what-is-new.html
(If the object is a log file group or tablespace, the parent schema is NULL.) In addition, the ndb_sync_excluded_objects table shows the reason for which the object has been excluded. NULL handling is performed according to the comparison semantics ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.42, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
If this mode is not enabled, division by zero inserts NULL and produces no warning. If this mode is enabled, division by zero inserts NULL and produces a warning. For INSERT IGNORE and UPDATE IGNORE, division by zero inserts NULL and produces a ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
Instead, MySQL converts the query to a query with no outer join operation if the WHERE condition is null-rejected. (That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. CHARSET(str) Returns the character set of the string argument, or NULL if the argument is NULL. mysql> SELECT DATABASE(); -> 'test' If there is no ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
This clause is also triggered on a column in a NESTED PATH clause when the latter has no match and a NULL complemented row is produced for it. on empty takes one of the following values: NULL ON EMPTY: The column is set to NULL; this is the default ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
conflict_fn column The conflict resolution function to be applied; one of NDB$OLD(), NDB$MAX(), NDB$MAX_DELETE_WIN(), NDB$EPOCH(), NDB$EPOCH_TRANS(), NDB$EPOCH2(), NDB$EPOCH2_TRANS(); NULL indicates that conflict resolution is not used for this ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
By default, when an operation requires additional space in a tablespace, InnoDB allocates pages to the tablespace and physically writes NULLs to those pages. You can disable innodb_extend_and_initialize on Linux systems to avoid physically writing ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. Retrained attributes are NULL (or NOT NULL) and, ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...