PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
The arguments are compared as decimal values if the other argument is a decimal or integer value, or as floating-point values if the other argument is a floating-point value. In all other cases, the arguments are compared as floating-point ... When ...
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. These functions are available for obtaining linestring properties: ST_EndPoint(ls) Returns the Point that is the endpoint of the ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For floating-point and fixed-point data types, M is the total number of digits that can be stored. M is the total number of digits (the precision) and D is the number of digits after the decimal point (the scale). The decimal point and (for negative ... For integer data types, M indicates the minimum display ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-remarks.html
If the master fails: If the internal commit point has been reached: The creation of the node group is rolled forward. If the master fails: If the internal commit point has been reached: The creation of the node group is rolled forward. The creation ... This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes ...
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
mysql> SELECT ST_GeometryType(ST_GeomFromText('POINT(1 1)')); +------------------------------------------------+ | ST_GeometryType(ST_GeomFromText('POINT(1 1)')) | +------------------------------------------------+ | POINT | ... The functions listed ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
For string or floating-point arguments, the return value has a floating-point type. For string or floating-point arguments, the return value has a floating-point type. mysql> SELECT RADIANS(90); -> 1.5707963267949 RAND([N]) Returns a random ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
Transactions are written to the binary log at the point when all the storage engines involved have confirmed that the transaction is prepared to commit. Since transactions hold all row locks between these two points in time, we know that they cannot ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
By default, the collation sorts characters having a code point listed in the DUCET table (Default Unicode Collation Element Table) according to the weight value assigned in the table. The collation sorts characters not having a code point listed in ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
When you select literal (or _introducer hexadecimal-value), do you obtain literal as a result? For example, the Japanese Katakana character Pe (ペ') exists in all CJK character sets, and has the code point value (hexadecimal coding) 0x30da. ucs2 ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
For example, you can insert the geometry return value from Point() directly into a POINT column: INSERT INTO t1 (pt_col) VALUES(Point(1,2)); GeomCollection(g [, g] ...) Constructs a GeomCollection value from the geometry arguments. LineString(pt [, ... MySQL provides a set of useful nonstandard functions for creating geometry ...