Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/charset-cp932.html
Some cp932 characters have two different code points, both of which convert to the same Unicode code point. When converting from Unicode back to cp932, one of the code points must be selected. (See http://support.microsoft.com/kb/170559/EN-US/.) The ... Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 ...
https://dev.mysql.com/charset-gb18030.html
Characteristics of the MySQL gb18030 Character Set Supports all code points defined by the GB 18030-2005 standard. Unassigned code points in the ranges (GB+8431A439, GB+90308130) and (GB+E3329A36, GB+EF39EF39) are treated as '?' (0x3F). Non-Chinese ... In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China ...
https://dev.mysql.com/data-types.html
For floating-point and fixed-point types, M is the total number of digits that can be stored (the precision). D applies to floating-point and fixed-point types and indicates the number of digits following the decimal point (the scale). fsp applies ... MySQL supports a number of SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data ...
https://dev.mysql.com/gis-class-curve.html
A Curve is a one-dimensional geometry, usually represented by a sequence of points. Particular subclasses of Curve define the type of interpolation between points. A Curve is simple if it does not pass through the same point twice, with the ...
https://dev.mysql.com/group-replication-understanding-consistency-guarantees.html
You configure a group's consistency guarantee based on the point at which you want to synchronize transactions across the group. To help you understand the concept, this section simplifies the points of synchronizing transactions across a group to ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/plugin-data-structures.html
Each general server plugin descriptor within the library descriptor also contains a pointer to a type-specific plugin descriptor. A type-specific plugin descriptor contains a type-specific API version number and pointers to the functions that are ...
https://dev.mysql.com/precision-math-examples.html
The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | +--------+------------------+ Example 2. Consider these statements: mysql> CREATE TABLE t (i ... This section provides some examples that show precision math query results in ...
https://dev.mysql.com/spatial-relation-functions-mbr.html
The bounding box of a point is interpreted as a point that is both boundary and interior. MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. The return ...
https://dev.mysql.com/cast-functions.html
mysql> SELECT 1 - 2; -> -1 mysql> SELECT CAST(1 - 2 AS UNSIGNED); -> 18446744073709551615 mysql> SELECT CAST(CAST(1 - 2 AS UNSIGNED) AS SIGNED); -> -1 If either operand is a floating-point value, the result is a floating-point value and is not ...
https://dev.mysql.com/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...All classes have properties, and instantiable classes may also have assertions (rules that define valid class ...
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-5.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.
