PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional dependence would apply. As with the previous example, a UNIQUE key over NOT NULL columns could be used instead of a primary key. Functional ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-locks.html
The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current lock. The mode column shows the lock mode; this is always one of S (indicating a shared lock) or X (an exclusive ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
The Version column in the output contains the table's schema object version. READ_ONLY and FULLY_REPLICATED, if set to 1, are shown in the Table options column. The Extent_space and Free extent_space columns are applicable only to NDB tables having ... ndb_desc provides a detailed description of one or more NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
--delimiter=character, -D character Causes the character to be used as a column delimiter. The column is nonempty only for Disk Data tables having nonindexed columns. --gci Adds a GCI column to the output showing the global checkpoint at which each ... ndb_select_all prints all rows from an NDB table to ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...In ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. The column descriptions indicate the corresponding CHANGE MASTER TO options from which the column values are ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is only available for tables without BLOB or TEXT columns. Creating a table with these columns with an explicit ...Of the ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
When selecting primary key columns, choose columns with the following characteristics: Columns that are referenced by the most important queries. For example, in a table containing information about people, you would not create a primary key on ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. SEQ_IN_INDEX The column sequence number in the index, starting with 1. That is, the number of indexed characters if the ...