PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/gis-class-multipoint.html
A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint ...
https://dev.mysql.com/doc/refman/9.7/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...Unless ...
https://dev.mysql.com/doc/refman/9.7/en/gis-wkt-functions.html
Functions such as ST_MPointFromText() and ST_GeomFromText() that accept WKT-format representations of MultiPoint values permit individual points within values to be surrounded by parentheses. For example, both of the following function calls are ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html
innodb_checkpoint_disabled Command-Line Format --innodb-checkpoint-disabled[={OFF|ON}] System Variable innodb_checkpoint_disabled Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF This is a debug option that is only ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
DATETIME A value that represents an earlier point in time is ordered before a value that represents a later point in time. If two values originally come from the MySQL DATETIME and TIMESTAMP types, respectively, they are equal if they represent the ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-key-migration.html
When you plan a key migration, use these points to decide whether it should be offline or online: Do not perform offline migration involving a keystore that is in use by a running server. This means that --defaults-file must not point to the same ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-start-phases.html
This occurs when the cluster has been shut down after having been in use, when it is desired for the cluster to resume operations from the point where it left off. Apply all redo information until the latest restorable global checkpoint has been ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-attributes.html
For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift up, from -2147483648 and 2147483647 to 0 and 4294967295. MySQL supports an extension for optionally specifying the display width of ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-decimal-characteristics.html
D is the number of digits to the right of the decimal point (the scale). Leftover Digits Number of Bytes 0 0 1–2 1 3–4 2 5–6 3 7–9 4 For example, a DECIMAL(18,9) column has nine digits on either side of the decimal point, so the integer part ... This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range of DECIMAL columns The declaration syntax for a DECIMAL column is ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html
(If strict SQL mode is not enabled, truncation for INSERT is permissible.) Handling of a numeric expression depends on what kind of values the expression contains: If any approximate values are present, the expression is approximate and is evaluated ... With precision math, exact-value numbers are used as given whenever ...