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/view-updatability.html
It is sometimes possible for a multiple-table view to be updatable, assuming that it can be processed with the MERGE algorithm. Some views are updatable and references to them can be used to specify tables to be updated in data change statements.
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_compression_algorithm (Session scope) The compression algorithm in use for the X Protocol connection for this session. The permitted compression algorithms are listed by the mysqlx_compression_algorithms system variable.
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
You can precede the SELECT by IGNORE or REPLACE to indicate how to handle rows that duplicate unique key values. With REPLACE, new rows replace rows that have the same unique key value. If neither IGNORE nor REPLACE is specified, duplicate unique ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
Terms then can then be added, removed, and selected from dictionaries and used as random values or as replacements for other values. Its arguments are the term to replace, the dictionary in which the term appears, and the dictionary from which to ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Items then can be selected from registered dictionaries and used as random values or as replacements for other values. Its arguments are the term to replace, the dictionary in which the term appears, and the dictionary from which to choose a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
This includes single-row and multiple-row INSERT and REPLACE statements that do not have a nested subquery, but not INSERT ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). If the second object has a member with a key matching a member in the first object, JSON_MERGE_PATCH() replaces the value in the first object with ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is ...
https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html
For information about replacing third-party packages with official MySQL packages, see the related APT guide or Yum guide. Note The compression algorithm changed from Gzip to XZ in MySQL Server 8.0.12; and the generic binary's file extension changed ...These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, and binaries in platform-specific package formats for selected ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
The LOW_PRIORITY clause of the INSERT, REPLACE, DELETE, and UPDATE statements. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other ...