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/flow-control-functions.html
The CASE statement cannot have an ELSE NULL clause, and it is terminated with END CASE instead of END. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join operation. If a table has many columns, and you query many different combinations of columns, it ...
https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
General information about adding collations is given in Section 12.14, “Adding a Collation to a Character Set”; it is assumed that you have read it and are familiar with the files involved. Warning User-defined collations are deprecated; you ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
A stopword is a word such as “the” or “some” that is so common that it is considered to have zero semantic value. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Ideographic languages such as Chinese and Japanese do not have word delimiters. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the utf8mb3 or utf8mb4 character set can be used, but not the ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-multipoint.html
A MultiPoint is simple if no two of its Point values are equal (have identical coordinate values). A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-multipolygon.html
A MultiPolygon is a MultiSurface object composed of Polygon elements. MultiPolygon Examples On a region map, a MultiPolygon could represent a system of lakes. MultiPolygon Assertions A MultiPolygon has no two Polygon elements with interiors that ...
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-data-formats.html
WKB values for more complex geometry values have more complex data structures, as detailed in the OpenGIS specification. Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known ...