PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/features.html
Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a flag when connecting to the server. This section describes some of the important ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
This might be desirable or necessary under multiple circumstances: A FIDO device is to be replaced with a different device. Note FIDO pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
It is possible to write a plugin that replaces the built-in full-text parser. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
In the original statement, replace the expression with a reference to the variable, which the optimizer can treat as a constant value: SET @keyval = FLOOR(1 + RAND() * 49); UPDATE t SET col_a = some_expr WHERE id = @keyval; Assign the random value ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
rename result table The thread is processing an ALTER TABLE statement, has created the new table, and is renaming it to replace the original table. The following list describes thread State values that are associated with general query processing ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
Whether use of temporary tables can be replaced by index access also depends on which parts of an index are used in a query, the conditions specified for these parts, and the selected aggregate functions. The most general way to satisfy a GROUP BY ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
When this is done, the current primary becomes a read-only secondary, and the specified group member becomes the read-write primary; this replaces the usual primary election process as described in Section 20.1.3.1, “Single-Primary Mode”. This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
From MySQL 8.0.20, you can do this, provided that the cloning operation does not remove and replace the data on the recipient. If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
During a remote cloning operation, the existing data on the joining member is removed, and replaced with a copy of the donor's data. Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by ...