PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-geometry.html
It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry subclasses. Geometry Properties A geometry value has the following properties: Its ...
https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html
You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any ...
https://dev.mysql.com/doc/refman/9.7/en/gis-polygon-property-functions.html
Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, ...
https://dev.mysql.com/doc/refman/9.7/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-columns-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of compression. Compression ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. However, because the efficiency of compression depends on the nature of your data, you can make decisions ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...