PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as equal. Collations for non-Unicode multibyte character sets For this type of collation, 8-bit (single-byte) and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
This includes characters in the Basic Multilingual Plane (BMP) range (U+0000 to U+FFFF) and supplementary characters outside the BMP range (U+10000 to U+10FFFF). The repertoire for function return values is determined based on the repertoire of only ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata. Figure 7.2 Remote Cloning Operation A remote cloning operation involves a local MySQL server instance (the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
It is cumbersome for applications to directly manage the set of candidate servers for connection attempts, and DNS SRV records provide an alternative: DNS SRV records enable a DNS administrator to map a single DNS domain to multiple servers. An ...A ...
https://dev.mysql.com/doc/refman/8.0/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. The features described in this section enable you to use MySQL as a document store, which is a schema-less, and ...If ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
As of MySQL 8.0.12, extended information is available for SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). The Message value in ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
The column is also indexed and the optimizer can take that index into account during execution plan construction. The optimization applies to these operators: =, <, <=, >, >=, BETWEEN, and IN(). For operators other than BETWEEN and IN(), either ...
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. See Section 14.16.3, “Functions That Create Geometry Values ...There are also functions to convert a string from WKT or WKB format to internal geometry ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html
These functions are installed by the Group Replication plugin in version 8.0.13 and higher. This section describes how changes are made to a running group, and the available functions. Important For the coordinator to be able to configure group wide ... You can configure an online group while Group Replication is running by using a set of functions, which rely on a group action ...