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/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. Of the types that represent all the required ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the recipient). CLONE ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
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 returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.0/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/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-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, ...