https://dev.mysql.com/non-typed-operators.html
Table 12.2 Operators Name Description AND, && Logical AND = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assign a value BETWEEN ... ->> Return value from JSON column after evaluating path and ...
https://dev.mysql.com/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do ...
https://dev.mysql.com/option-modifiers.html
The “enabled” form of the option may be specified in any of these ways: --column-names --enable-column-names --column-names=1 The values ON, TRUE, OFF, and FALSE are also recognized for boolean options (not case-sensitive). Some options are ...
https://dev.mysql.com/outer-join-simplification.html
(That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it evaluates to FALSE or UNKNOWN for any NULL-complemented row generated for the operation. Table expressions in the FROM ...
https://dev.mysql.com/replication-gtids-failover.html
There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new slave which can then be used for scaleout, being promoted to master as necessary for failover. Each identifier uniquely ...
https://dev.mysql.com/replication-gtids-lifecycle.html
If one of the situations described there applies on a server, set binlog_gtid_simple_recovery=FALSE in the server's configuration file before starting it. The life cycle of a GTID consists of the following steps: A transaction is executed and ...
https://dev.mysql.com/replication-options-slave.html
This section explains the server options and system variables that apply to slave replication servers and contains the following: Startup Options for Replication Slaves Options for Logging Slave Status to Tables System Variables Used on Replication ...
https://dev.mysql.com/rewriter-query-rewrite-plugin-usage.html
This is subject to false positives, but serves as a quick rejection test. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 5.6.4.1, ...
https://dev.mysql.com/row-subqueries.html
If the t2 row col3 and col4 values are not equal the col1 and col2 values of any t1 row, the expression is FALSE and the query returns an empty result set. Scalar or column subqueries return a single value or a column of values. A row subquery is a ...
https://dev.mysql.com/solaris-installation.html
Note MySQL 8.0 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...
