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-compressed-data.html
If file system block sizes differ, an error similar to the following is reported: ERROR 3868 (HY000): Clone Configuration FS Block Size: Donor value: 114688 is different from Recipient value: 4096. The following requirements apply when cloning ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File '/path/to/tablespace_name.ibd' already exists. The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. mysql> GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
If the required binary logs are not available, a replication handshake error is reported. In this case, an error message is issued, and you must set the channel up manually. In addition to cloning data, a cloning operation extracts replication ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
If named-pipe connections are not supported or if the user making the connection is not a member of the Windows group specified by the named_pipe_full_access_group system variable, an error occurs. If the server was not started with the named_pipe ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'connection%'; +------------------------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... This section describes how ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a nontransactional storage engine, MySQL stops processing the statement at the row ...If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html
If a CPU number is an integer outside the permitted range or is not an integer, an error occurs. CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
If expression evaluation causes truncation or provides incorrect input to a function, the CREATE TABLE statement terminates with an error and the DDL operation is rejected. In MySQL 8.0.22 and later, if the column is also declared as NOT NULL, ...