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/clone-plugin-remote.html
Instructions for creating the clone user and granting the required privileges are included in the remote cloning example that follows this prerequisite information. Refer to your operating system documentation for information about how to determine ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...
https://dev.mysql.com/doc/refman/8.0/en/clone.html
For additional information about cloning data from a remote MySQL server instance, see Section 7.6.7.3, “Cloning Remote Data”. CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] 'clone_dir'; | INSTANCE FROM 'user'@'host':port ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
For additional information about transaction access mode, including ways to change the default mode, see Section 15.3.7, “SET TRANSACTION Statement”. See Chapter 31, Connectors and APIs, or the documentation for your API, for more information.
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Your identity is based on two pieces of information: Your MySQL user name. (See Section 14.15, “Information Functions”.) It returns a value in user_name@host_name format that indicates the User and Host values from the matching user table row.
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: The mysqld process is killed ...An unexpected computer shutdown occurs (for example, the computer is turned ...
https://dev.mysql.com/doc/refman/8.0/en/create-role.html
Each role name uses the format described in Section 8.2.5, “Specifying Role Names”. CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are named collections of privileges. To use this statement, you must ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
The data stored in the table can be used when creating a connection to a FEDERATED table: CREATE TABLE t (s1 INT) ENGINE=FEDERATED CONNECTION='s'; For more information, see Section 18.8, “The FEDERATED Storage Engine”. CREATE SERVER is not ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
The Information Schema CHECK_CONSTRAINTS table provides information about CHECK constraints defined on tables. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
For information about how the MySQL implementation of foreign key constraints differs from the SQL standard, see Section 1.6.2.3, “FOREIGN KEY Constraint Differences”. For information about using system variables, see Section 7.1.9, “Using ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...