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/drop-user.html
For additional information, including how to identify which objects name a given account as the DEFINER attribute, see Orphan Stored Objects. Each account name uses the format described in Section 8.2.4, “Specifying Account Names”. (For ...The ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
AES_DECRYPT() decrypts the encrypted string crypt_str using the key string key_str, and returns the original (binary) string in hexadecimal format. As of MySQL 8.0.30, these functions support the use of a key derivation function (KDF) to create a ...
https://dev.mysql.com/doc/refman/8.0/en/end-markers-in-json-system-variable.html
This variable affects both optimizer traces and the output of EXPLAIN FORMAT=JSON. When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
This is also true for a semijoin, provided the optimization strategy employed is firstMatch (see Section 10.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations”). This optimization improves the efficiency of ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
Make sure that you are connected to the server, as discussed in the previous section. Doing so does not in itself select any database to work with, but that is okay. At this point, it is more important to find out a little about how to issue ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-priority-based-filtering.html
To affect how log_filter_internal permits or suppresses error, warning, and information events intended for the error log, set the log_error_verbosity and log_error_suppression_list system variables. For information about filter configuration, see ... The log_filter_internal log filter component implements a simple form of log filtering based on error event priority and error ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
The information produced by many of the MySQL-specific SHOW statements can be obtained in more standard fashion by using SELECT to query INFORMATION_SCHEMA. (In MySQL Server, these functions can take a variable number of arguments.) The BIT_COUNT(), ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
In early 2008, CA AB 1298 added medical and health insurance information to PII data. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically resides. The connection string specifies the server name, login credentials, port number and database/table ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
If the statement produces a result set, each column is converted to internal storage engine format that the FEDERATED engine expects and can use to display the result to the client that issued the original statement. When you create a table using ...