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-function-argument-handling.html
In MySQL, the SRID value is an integer associated with the geometry value. In MySQL, the only valid empty geometry is represented in the form of an empty geometry collection. Spatial values, or geometries, have the properties described in Section ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. The basis for these types is described in Section 13.4.2, “The ...
https://dev.mysql.com/doc/refman/8.4/en/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
If you do not specify this option, MySQL native authentication (the mysql_native_password plugin) is assumed. The authentication plugin used by default when you create user accounts in MySQL 8 is the caching SHA-2 authentication plugin ... START ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines-other.html
For more information on developing a customer storage engine that can be used with the Pluggable Storage Engine Architecture, see MySQL Internals: Writing a Custom Storage Engine. Other storage engines may be available from third parties and ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
For information about the scope of local variables and how MySQL resolves ambiguous names, see Section 15.6.4.2, “Local Variable Scope and Resolution”. System variables and user-defined variables can be used in stored programs, just as they can ...
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/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.4/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...