Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/numeric-type-overview.html
For floating-point and fixed-point 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 ...
https://dev.mysql.com/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/charset-unicode-sets.html
Although utf8 is currently an alias for utf8mb3, at some point utf8 will become a reference to utf8mb4. By default, the collation sorts characters having a code point listed in the DUCET table (Default Unicode Collation Element Table) according to ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/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/c-api-prepared-statement-data-structures.html
Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data structure. To specify the statement to prepare, pass the MYSQL_STMT ...To provide input parameters for a prepared statement, set up MYSQL_BIND structures and pass them to ...
https://dev.mysql.com/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/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 ...
https://dev.mysql.com/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. (Note that π radians equals 180 degrees.) mysql> SELECT RADIANS(90); -> ...
https://dev.mysql.com/ldml-rules.html
Character Representation Characters named in LDML rules can be written literally or in \unnnn format, where nnnn is the hexadecimal Unicode code point value. Orderings are given as a set of rules that begin with a reset rule that establishes an ...
https://dev.mysql.com/mysqlbinlog.html
For other usage examples, see the discussion later in this section and in Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”. For example: shell> mysqlbinlog --start-datetime="2005-12-25 11:25:56" binlog.000003 This option ... The server's binary log consists of files containing “events” that describe modifications to database ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-point-p-3.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
