Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.4/en/spatial-index-optimization.html
They exist only for backward compatibility (for example, the ability to perform a dump in MySQL 8.2 and restore in MySQL 8.3). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
In addition, Section 14.16.7, “Geometry Property Functions”, discusses several functions that construct new geometries from existing ones. OpenGIS proposes a number of functions that can produce geometries. These functions support all argument ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
If no channel is named and no extra channels exist, the statement applies to the default channel. ] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. STOP REPLICA requires the ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
The following sections provide additional information about SQL syntax for statements related to these objects, and about object processing: For each object type, there are CREATE, ALTER, and DROP statements that control which objects exist and how ... This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Similarly, any changes to existing stored routines or triggers must be carried out explicitly on all Cluster SQL nodes, using the appropriate ALTER or DROP statements on each MySQL Server accessing the cluster. Some of the restrictions noted here ...
https://dev.mysql.com/doc/refman/8.4/en/string-collating.html
The existing character sets provide the best documentation and examples to show how these functions are implemented. For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
This is useful primarily when you must be compliant with old applications that depend on the existence of a column but that do not actually use its value. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...