https://dev.mysql.com/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The syntax means “there is some b to which a is not equal.” Using <> SOME instead helps ensure that everyone understands the true ...The ...
https://dev.mysql.com/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/derived-table-optimization.html
The optimizer propagates an ORDER BY clause in a derived table or view reference to the outer query block if these conditions are all true: The outer query is not grouped or aggregated. What is true for materialization of derived tables is also true ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/mysql-cluster-security-mysql-privileges.html
The same thing is true with respect to the CREATE USER and DROP USER statements. If these conditions are true, then anyone, anywhere can start a MySQL Server with --ndbcluster --ndb-connectstring=management_host and access this NDB Cluster. This is ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/mysql-cluster-tcp-definition.html
TcpBind_INADDR_ANY Setting this parameter to TRUE or 1 binds IP_ADDR_ANY so that connections can be made from anywhere (for autogenerated connections). TCP/IP is the default transport mechanism for all connections between nodes in an NDB Cluster.
https://dev.mysql.com/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For the preceding example, if t2 contains any rows, even rows with nothing but NULL values, the EXISTS condition is TRUE. Formally, it answers the ...
https://dev.mysql.com/string-comparison-functions.html
The same is true for aggregate queries involving NULL and comparisons using NOT RLIKE or NOT REGEXP. Table 12.8 String Comparison Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare ...
https://dev.mysql.com/mysql-nutshell.html
This is true for sorts performed entirely in memory as well as for sorts that require writing to and reading from disk. This section summarizes what has been added to, deprecated in, and removed from MySQL 8.0. A companion section lists MySQL ...
https://dev.mysql.com/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
