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/optimizing-spatial-analysis.html
The most typical operations are: Point queries that search for all objects that contain a given point Region queries that search for all objects that overlap a given region MySQL uses R-Trees with quadratic splitting for SPATIAL indexes on spatial ... For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-numbers.html
Approximate-value data types and numeric literals are handled as floating-point numbers. For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The DECIMAL data type is a fixed-point ... The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
The highest value present in the col column prior to the INSERT is 31, and the next available value in the AUTO_INCREMENT series is 35, so the inserted values for col begin at that point and the results are as shown for the SELECT query. This ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-stored-procs.html
Do the preceding limitations affect the ability of MySQL to do point-in-time recovery? A.4.28. If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/9.7/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/9.7/en/gis-polygon-property-functions.html
This function processes geometry collections by computing the centroid point for components of highest dimension in the collection. Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...However, GTIDs only provide a means to realize which transactions the joining member is ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format. If the floating-point formats differ but you have not ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Floating point: FLOAT and DOUBLE are supported along with their aliases. REAL is also treated as floating point, but UNSIGNED FLOAT and UNSIGNED DOUBLE are deprecated in MySQL, and are not supported by MLE. Most MySQL data types are supported for ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions.html
If D is 0, the result has no decimal point or fractional part. The optional third parameter enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between separators. For functions that ...