Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-operator-functions.html
This function processes geometry collections by extracting all vertex points of all components of the collection, creating a MultiPoint value from them, and computing its convex hull. OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-simple-statements.html
A simple statement is static, and cannot be modified after creation; in other words, it cannot be parametrized. A simple statement returns a result set which can be used to access data (rows), metadata, and diagnostic information. A simple ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Passing a MySQL zero date (00-00-0000) or zero-in-date value (such as 00-01-2023) leads to the creation of an Invalid Date instance of Date. Most MySQL data types are supported for MLE stored program input and output arguments, as well as for ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-limitations.html
As with SQL stored routines, JavaScript stored routines with a variable number of arguments are not supported; each argument and its type must be specified at creation time. MySQL JavaScript stored programs are subject to the limitations and ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-anomalydetector.html
trainOptions (Object): The training options specified in the constructor when creating an instance of AnomalyDetector. AnomalyDetector Constructor AnomalyDetector.train() AnomalyDetector.fit() AnomalyDetector.predict() AnomalyDetector.score() ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-llm.html
LLM Constructor LLM.unload() LLM.generate() LLM.embed() LLM.rag() This class represents a large language model. The API also provides convenience methods; see Section 27.3.10.8, “Convenience Methods”. Both versions of these methods support ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-transactions.html
setSavepoint(): Create a new savepoint with the given name (and return it). MLE supports a JavaScript MySQL transaction API which mimics the actions of most MySQL transactional SQL statements. All of the functions listed here, along with their ...
https://dev.mysql.com/doc/refman/9.7/en/starting-server-troubleshooting.html
You can create a my.cnf file and specify startup options for the engines that you plan to use. This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.4, ...