PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
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 SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Transactions are executed optimistically and then, at commit time, are checked for conflicts. MySQL Group Replication is designed to be deployed in a cluster environment where server instances are very close to each other. Bi-directional ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. Consider the following stored procedure, which adds .0001 to a variable 1,000 times. That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the ...These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
To configure that setting explicitly at startup, use these lines in the server my.cnf file: [mysqld] protocol_compression_algorithms=zlib,zstd,uncompressed To set and persist the protocol_compression_algorithms system variable to that value at ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition can work with keyring_aws on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Debian, Ubuntu, macOS, and Windows. MySQL Enterprise Edition does not support the use of keyring_aws on these platforms: EL6 Generic Linux (glibc2.12) SLES 12 (with versions after MySQL Server 5.7) Solaris The discussion here assumes that you are familiar with AWS in general and KMS in ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. For subpartitions not ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
From MySQL 8.0.27, Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
As of MySQL 8.0.14, additional undo tablespaces can be created at runtime using SQL. Prior to MySQL 8.0.23, an undo tablespace is extended four extents at a time. As of MySQL 8.0.14, additional undo tablespaces can be created at runtime using CREATE ...Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be ... Undo tablespaces ...