PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. All tables that are to be combined must have identical structure (same column names and types, same indexes, and so forth). empty-space The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...The INNODB_SYS_VIRTUAL table has these columns: TABLE_ID An identifier representing the table associated with the virtual column; the same value as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...You must also specify the name of a table when invoking ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
SET @ciphertext = asymmetric_encrypt(@algo, 'My secret text', @pub); SET @plaintext = asymmetric_decrypt(@algo, @ciphertext, @priv); In either case, the algorithm specified for the encryption and decryption functions must match that used to generate ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
See also Indexing a Generated Column to Provide a JSON Column Index. MySQL now supports the specification of generated columns in CREATE TABLE and ALTER TABLE statements. Values of a generated column are computed from an expression specified at ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html
The POS value for a virtual generated column encodes the column sequence number and ordinal position of the column. The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table ...For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
TcpBind_INADDR_ANY Setting this parameter to TRUE or 1 binds IP_ADDR_ANY so that connections can be made from anywhere (for autogenerated connections). Unique hash indexes are updated only when the unique index columns are updated, in which case a ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
Because gtid_next is set to the GTID already assigned by the source, the replica does not attempt to generate a new GTID for this transaction, but instead uses the GTID stored in gtid_next. What changes are assigned a GTID? The typical scenario is ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...Suppose that the server's default character set was latin1 and col1 is defined as CHAR(50) but its contents are sjis ...