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/faqs-mysql-cluster.html
Creating a primary key or unique index also creates an ordered index, unless this index is created with USING HASH. In other words: A primary key or unique index on a Cluster table normally takes up 31 to 35 bytes per record. However, if the primary ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
COLUMN_KEY Whether the column is indexed: If COLUMN_KEY is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index. If COLUMN_KEY is UNI, the column is the first column of a UNIQUE index. (A UNIQUE index permits multiple NULL values, but you can tell whether the column permits NULL by checking the Null column.) If COLUMN_KEY is MUL, the column is the first column of a nonunique index in which multiple occurrences of a given value are permitted within the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
A “record” in the keystore consists of data (the key itself) and a unique identifier through which the key is accessed. The key_id and user_id arguments form a unique combination indicating which key in the keyring to use. Syntax: bool ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
Where a table has secondary unique keys, these values are also added to the transaction's writeset to detect the case where there are transaction dependencies implied by different transactions affecting the same unique key value, and so requiring ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. Note REPLACE makes sense only if a table has a ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
Key Whether the column is indexed: If Key is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index. If Key is UNI, the column is the first column of a UNIQUE index. (A UNIQUE index ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
ONLY_FULL_GROUP_BY Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns.
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
| ADD [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... If you add a UNIQUE INDEX or PRIMARY KEY to a table, MySQL stores it before any nonunique index to permit detection of duplicate keys as ...