Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-function-argument-handling.html
For computations on multiple geometry values, all values must be in the same SRS or an error occurs. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-reference-systems.html
For computations on multiple geometry values, all values must have the same SRID or an error occurs. A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-type-overview.html
Attempts to insert values with a different SRID produce an error. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
Omitting deallocation does not produce an error but memory consumed during stored procedure execution is otherwise not freed until routine execution has finished. The prepared statement API allows supported SQL statements (see SQL Syntax Permitted ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-simple-statements.html
A simple statement containing one or more ? parameter markers raises an error. A simple statement returns a result set which can be used to access data (rows), metadata, and diagnostic information. A simple statement is static, and cannot be ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-language-support.html
console.log() and console.error() are also supported (see Section 27.3.12, “JavaScript Stored Program Examples”). JavaScript language support in MySQL conforms to the ECMAScript 2024 Specification, and uses strict mode by default. This ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-limitations.html
Excessive recursion may cause a program to fail, like this: mysql> SELECT recursive_sum(1000); ERROR 6113 (HY000): JavaScript> Maximum frame limit of 1000 exceeded. MySQL JavaScript stored programs are subject to the limitations and restrictions ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-convenience-methods.html
An error is thrown if model with the given name does not exist. The GenAI API provides the convenience methods described in this section under the ml namespace. These methods act as wrappers for the LLM methods; rather than being invoked as LLM ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-llm.html
This is optional, but recommended, since doing so can reduce memory usage; after unloading, any subsequent attempt to use the instance raises an error. LLM Constructor LLM.unload() LLM.generate() LLM.embed() LLM.rag() This class represents a large ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-table.html
count(): Returns the number of rows in this table if it exists in the current database, otherwise throws an error. The Table object represents a database table existsInDatabase(): Returns true if the table exists in the current database, otherwise ...