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/fulltext-natural-language.html
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 a set of one or more columns included in a FULLTEXT index. For each row in the ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-linestring.html
A LineString is a Curve with linear interpolation between points. LineString Examples On a world map, LineString objects could represent rivers. LineString Properties A LineString has coordinates of segments, defined by each consecutive pair of ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-multicurve.html
A MultiCurve is a geometry collection composed of Curve elements. A MultiCurve is simple if and only if all of its elements are simple; the only intersections between any two elements occur at points that are on the boundaries of both elements. A ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-polygon.html
A Polygon is a planar Surface representing a multisided geometry. It is defined by a single exterior boundary and zero or more interior boundaries, where each interior boundary defines a hole in the Polygon. Polygon Examples On a region map, ...
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. There are also functions to convert a string from WKT or WKB ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this function. If you do not want to use this function in a group, do not set it up, in ...