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/performance-schema-session-account-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. The session_account_connect_attrs table has these indexes: Primary key on (PROCESSLIST_ID, ATTR_NAME) TRUNCATE TABLE is not permitted for ...For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-session-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. The session_connect_attrs table has these indexes: Primary key on (PROCESSLIST_ID, ATTR_NAME) TRUNCATE TABLE is not permitted for the ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT DISTINCT, but it is inefficient to generate all matching rows first only to eliminate duplicates later. A semijoin is a preparation-time ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
The RECURSIVE keyword must be included if any CTE in the WITH clause is recursive. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
These variables are unavailable unless the appropriate keyring plugin is installed (see Section 8.4.4.3, “Keyring Plugin Installation”). keyring_aws_cmk_id Command-Line Format --keyring-aws-cmk-id=value System Variable keyring_aws_cmk_id Scope ...See the description of that variable for details, as well as for considerations to take into account if you create the directory ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, is used with the SET {ACTIVE | INACTIVE} clause to mark an InnoDB undo tablespace as active or inactive. A keyring plugin must be installed and configured before encryption can be enabled. ALTER ...It ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, must be specified to drop an undo tablespace. mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...