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
| 1.3114095926285 | +----+-------------------------------------+-----------------+ 2 rows in set (0.00 sec) A phrase that is enclosed within double quote (") characters matches only rows that contain the phrase literally, as it was typed. By ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
There are no special operators, with the exception of double quote (") characters. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
Its coordinates in its spatial reference system, represented as double-precision (8-byte) numbers. 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 ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/gis-polygon-property-functions.html
These functions are available for obtaining polygon properties: ST_Area({poly|mpoly}) Returns a double-precision number indicating the area of the Polygon or MultiPolygon argument, as measured in its spatial reference system. Functions in this ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/information-schema-innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. For related usage information and examples, see Section 17.15.3, “InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
Image data, such as JPEG, is typically already compressed and so does not benefit much from being stored in a compressed table; the double compression can waste CPU cycles for little or no space savings. This section describes some internal ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
When you compress the data in the application and store the results in a compressed table, extra space savings are extremely unlikely, and the double compression just wastes CPU cycles. Most often, the internal optimizations described in InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files. This section describes techniques for moving or copying some or all InnoDB tables ...