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/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... It can be useful when inserting all columns from the source table into the target table, and no ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components, and the keyring_file and keyring_encrypted_file plugins are not intended as a regulatory compliance solution. Security standards such ... The component_keyring_file keyring component stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html
Table 14.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
In NDB 8.0.22 and later, START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. This function has the form shown here: key = KDF(random_salt, password) The key so generated is then used to encrypt the backup data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
To support NDB Cluster, you should update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf ...Note The options shown here should not be confused with those that are used in config.ini global configuration ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-configuration.html
In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration files. For our four-node, four-host NDB Cluster (see Cluster nodes and host computers), it is necessary to write four configuration ...For more information on connection strings, see Section 25.4.3.3, “NDB Cluster Connection ...
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
For attempts to disable partial_revokes at runtime, an error occurs and the partial_revokes value remains unchanged. Using Partial Revokes Partial Revokes Versus Explicit Schema Grants Disabling Partial Revokes Partial Revokes and Replication Note ... Prior to MySQL 8.0.16, it is not possible to grant privileges that apply globally except for certain ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
If strict mode is enabled, inserts and updates involving division by zero are prohibited, and an error occurs. In other words, inserts and updates involving expressions that perform division by zero can be treated as errors, but this requires ...(If ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. You must obtain (or create) a suitable security certificate that you ...If either server does not support encrypted connections (because it has not been compiled or configured for them), replication through an encrypted connection is not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source that you want to replicate. There are some ... This section describes how to set up a MySQL server to use binary log file position based ...