PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
ST_Distance_Sphere() handles its arguments as described in the introduction to this section, with these exceptions: Supported geometry argument combinations are Point and Point, or Point and MultiPoint (in any argument order). The functions in this ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
Observe that the order of coordinates depends on the SRID used. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
Up to one strategy of each type may be specified, and they may be given in any order. OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
Prior to MySQL 8.0.18, the only permitted geographic argument types are Point and Point, or Point and MultiPoint (in any argument order). The OpenGIS specification defines the following functions to test the relationship between two geometry values ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
For the CHAR, VARCHAR, TEXT, ENUM, and SET data types, you can declare a column with a binary (_bin) collation or the BINARY attribute to cause comparison and sorting to use the underlying character code values rather than a lexical ordering. The ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
A subquery can contain many of the keywords or clauses that an ordinary SELECT can contain: DISTINCT, GROUP BY, ORDER BY, LIMIT, joins, index hints, UNION constructs, comments, functions, and so on. All subquery forms and operations that the SQL ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
MySQL does not support LIMIT in subqueries for certain subquery operators: mysql> SELECT * FROM t1 WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1); ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ... In general, you cannot modify a table and select from the same table in a ...