PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table ...For example, if 10 rows are read into a buffer and the buffer is passed to the next inner loop, each row read in the inner loop can be compared against all 10 rows in the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. When a new row is inserted into a partitioned table, it is these ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
Event collection provides access to information about synchronization calls (such as for mutexes) file and table I/O, table locks, and so forth for the server and for several storage engines. Performance Schema tables are considered local to the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
(Row-based replication, however, simply replicates the value returned by the function or stored program, so its effect on table rows and data is the same on both the source and replica.) See Section 19.5.1.16, “Replication of Invoked Features”, ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-elements.html
Prior to MySQL 8.0.14, the monitoring tables are INFORMATION_SCHEMA tables; see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”. The INFORMATION_SCHEMA tables now are deprecated; expect them to be removed in a future version of MySQL. For ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. You should also bear in mind that ROW() is ...VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number] row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] value_list: value[, value][, ...] column_designator: column_index The VALUES statement consists of the VALUES keyword followed by a list of one or more row constructors, separated by ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT ...The function ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
You should never alter the structure of tables in the mysql database in any manner whatsoever except by means of the procedure that is described in Chapter 3, Upgrading MySQL. MySQL stores accounts in the user table of the mysql system database. An ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. The ALTER TABLE statement produces three warning messages (strict SQL mode is disabled for the example to ...mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
Table 8.27 Plugin and Library Names for FIDO Authentication Plugin or File Plugin or File Name Server-side plugin authentication_fido Client-side plugin authentication_fido_client Library file authentication_fido.so, authentication_fido_client.so ...