Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/group-replication-system-variables.html
Group Replication's Group Communication System (GCS) is not available to validate the values until that point. group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
Binary logs containing transactions without GTIDs cannot be used on servers where GTIDs are enabled, so backups taken before this point cannot be used with your new configuration. If you use binary logs for anything other than replication, for ...