PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
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/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometrycollection.html
Restrictions may be based on: Element type (for example, a MultiPoint may contain only Point elements) Dimension Constraints on the degree of spatial overlap between elements . A GeomCollection is a geometry that is a collection of zero or more ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-multisurface.html
Surfaces within a MultiSurface have boundaries that intersect at most at a finite number of points. A MultiSurface is a geometry collection composed of surface elements. MultiSurface Assertions Surfaces within a MultiSurface have no interiors that ...
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
mysql> SET @g = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@g)); +--------------------------------+ | ST_AsText(ST_GeomFromText(@g)) | +--------------------------------+ | LINESTRING(1 1,2 2,3 3) | ... MySQL supports the ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
This is because MySQL is dependent on the host system for name resolution, but has no way of knowing whether it is working—from MySQL's point of view the problem is indistinguishable from any other network timeout. This section also covers the ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
However, at this point, you cannot distinguish whether a NULL represents a regular grouped value or a super-aggregate value. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
There is a built-in group membership service that keeps the view of the group consistent and available for all servers at any given point in time. The most common way to create a fault-tolerant system is to resort to making components redundant, in ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
When you set a timeout, it also prevents new transactions starting on the primary from that point on. This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
During state transfer from a donor's binary log, the joining member replicates and applies the required transactions from the donor's binary log, applying the transactions as they are received, up to the point where the binary log records that the ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...