PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
The BINARY operator also causes trailing spaces in comparisons to be significant. For a character column defined with the BINARY attribute, MySQL assigns the table default character set and the binary (_bin) collation of that character set. Unlike ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/9.7/en/flow-control-functions.html
Otherwise, the result is an integer type (with one exception): If all integer types are all signed or all unsigned, the result is the same sign and the precision is the highest of all specified integer types (that is, TINYINT, SMALLINT, MEDIUMINT, ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/9.7/en/identifiers.html
Use of the dollar sign as the first character in the unquoted name of a database, table, view, column, stored program, or alias is deprecated, including such names used with qualifiers (see Section 11.2.2, “Identifier Qualifiers”). An unquoted ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/9.7/en/enterprise-encryption-functions.html
priv_key_str is the private key string to use for signing the digest string. digest_type is the algorithm to be used to sign the data. asymmetric_verify(algorithm, text, sig_str, pub_key_str, digest_type) Verifies whether the signature string ...
https://dev.mysql.com/doc/refman/9.7/en/enterprise-encryption-usage.html
They are good for encrypting small amounts of data and creating and verifying signatures. For the component functions, signatures do not require a digest, and can use any data string. The digest type in these functions refers to the algorithm that ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
This statement prevents new GTIDs from being generated and assigned to the transactions in the dump file as they are executed, so that the original GTIDs for the transactions are used. You can either replace the value of gtid_purged with a specified ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-plugin.html
There is a 20-second wait for each connection attempt, so the presence of a long list of invalid servers can significantly affect the keyring_okv plugin’s connection time and therefore the server startup time. There is a 20-second wait for each ...
https://dev.mysql.com/doc/refman/9.7/en/using-encrypted-connections.html
If the server discovers that the CA certificate is self-signed, it writes a warning to the error log. (The certificate is self-signed if created automatically by the server.) MySQL also provides these system variables for server-side ... Several ...