Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
If the function does take arguments, an args item is needed, and the arguments must be given in the order listed in the function description. For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
In this case, the file name has .gz and .pwd_id.enc suffixes added, corresponding to the order in which those operations occur. This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
All bytes are significant in comparisons, including ORDER BY and DISTINCT operations. All bytes are significant in comparisons, including ORDER BY and DISTINCT operations. The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that ...
https://dev.mysql.com/doc/refman/8.4/en/bit-value-literals.html
Due to the difference in result types, the displayed values differ: High-order 0 digits are not displayed for the numeric result. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
The algorithms can be specified in any order, but it is not an order of preference - the algorithm negotiation process attempts to use zlib, then zstd, then uncompressed, if they are specified. ] CHANGE REPLICATION SOURCE TO changes the parameters ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
Incompatibilities might occur because the storage format for a data type has changed or because its sort order has changed. FOR UPGRADE discovers these incompatibilities: The indexing order for end-space in TEXT columns for InnoDB and MyISAM tables ...option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-dns-srv.html
For information about DNS SRV, including how a record defines the preference order of the listed servers, see RFC 2782. A client that receives a DNS SRV lookup result attempts to connect to the MySQL server on each of the listed hosts in order of ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query optimizers, including that of MySQL, perform a more or less exhaustive search for an ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
A correlated column can be present only in the subquery's WHERE clause (and not in the SELECT list, a JOIN or ORDER BY clause, a GROUP BY list, or a HAVING clause). A correlated subquery is a subquery that contains a reference to a table that also ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.