PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
If in the join result co.Code is NULL-complemented, co.Name is as well. Functional dependence in outer joins is thus linked to whether determinant columns belong to the left or right side of the LEFT JOIN. Determination of functional dependence ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
Lateral derived tables are subject to these restrictions: A lateral derived table can occur only in a FROM clause, either in a list of tables separated with commas or in a join specification (JOIN, INNER JOIN, CROSS JOIN, LEFT [OUTER] JOIN, or RIGHT ... A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
NDB 8.0 makes use of the MySQL data dictionary to distribute schema information to SQL nodes joining a cluster and to synchronize new schema changes between existing SQL nodes. A user or role having NDB_STORED_USER, along with its privileges, is ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
denormalized A data storage strategy that duplicates data across different tables, rather than linking the tables with foreign keys and join queries. One of the stages in designing a normalized database is to identify data that is duplicated, ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...But for some questions, the only information that matters is whether there is a match, not the number of ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
The table_references clause lists the tables involved in the join, as described in Section 15.2.13.2, “JOIN Clause”. The preceding examples use INNER JOIN, but multiple-table DELETE statements can use other types of join permitted in SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
A MySQL server at version X can only join and reach ONLINE status in a replication group if the group's communication protocol version is less than or equal to X. When a new member joins a replication group, it checks the communication protocol ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
In MySQL 8.0.17 and later, for state transfer from the binary log, the joiner only selects a donor that is running a lower or equal patch version of MySQL Server compared to itself. For a remote cloning operation, the joiner selects a donor that is ... Group Replication's distributed recovery process has a number of built-in measures to ensure fault tolerance in the event of any problems during the ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
For this to work, the view must use an inner join (not an outer join or a UNION). If the view is a join view, all components of the view must be updatable (not materialized). If a view is a join view, at least one component of the view must be ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
Joins are not directly supported; conditions involving multiple tables are pushed separately where possible. This reduces the number of rows which must be handled by the SQL node during join processing. Beginning with NDB 8.0.20, an outer join using ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...