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/create-table.html
Columns using BLOB, TEXT, SET, ENUM, BIT, or spatial data types are not permitted; columns that use floating-point number types are also not permitted. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-operator-functions.html
OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable according to the Open Geospatial Consortium specification. MySQL also implements certain ...
https://dev.mysql.com/doc/refman/9.7/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-object-shapes.html
The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object shapes. The return values 1 and 0 indicate true and false, respectively, except that distance functions ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs can set the global SQL mode to match site server operating requirements, ...
https://dev.mysql.com/doc/refman/9.7/en/choosing-types.html
This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-mysql.html
These are described in the following list, along with their analogous SQL functions: rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 <= v < 1.0. The following SQL built-in functions can be called directly from the ...