Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
At this time, there are no active replication threads, so the THREAD_ID columns are NULL and the SERVICE_STATE columns have a value of OFF. After STOP REPLICA, the THREAD_ID columns become NULL and the SERVICE_STATE columns for threads that no ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-modify.html
The modify(SearchConditionStr) function is for modifying documents in a collection, similar to an UPDATE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that are to be ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented.
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_IsClosed() returns 0 if ls is not closed, and NULL ...You can extract particular points of a LineString, count the number of points that it contains, or obtain its ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
bool *is_null This member points to a bool variable that is true if a value is NULL, false if it is not NULL. For input, set *is_null to true to indicate that you are passing a NULL value as a statement parameter. is_null is a pointer to a boolean ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI routine. Vector embeddings are a numerical representation of the text that capture the semantics of the data and relationships to other data. You ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-generate-embeddings.html
This section describes how to generate vector embeddings using the ML_EMBED_ROW routine. Vector embeddings are a numerical representation of the text that capture the semantics of the data and relationships to other data. You can pass the text ...