Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response for the given natural-language query. As of MySQL 9.4.1, the ML_GENERATE lets you generate text-based responses for queries ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-vector-store-load.html
| NULL | 0 | SCHEDULED | | 0x11EF799F5D99812188CC020017091C01 | 1 | 2024-09-23 11:31:24.887685 | Task starting. The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are stored in the bucket, and loads the ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The operation is either committed, with applicable changes persisted to ...
https://dev.mysql.com/doc/refman/8.4/en/audit-api-message-emit.html
Each value can be a string or numeric value, or NULL. Example: mysql> SELECT audit_api_message_emit_udf('component_text', 'producer_text', 'message_text', 'key1', 'value1', 'key2', 123, 'key3', NULL) AS 'Message'; +---------+ | Message | +---------+ ... The audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
Each row from the buffer that does not have its match flag enabled is extended by NULL complements (NULL values for each column in the second operand) and sent for further extensions by the remaining join operations. In MySQL, a Batched Key Access ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
NULL or an expression that is derived from NULL has a coercibility of 6. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, it should be clear that ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is returned. For a nonexistent table, CHECKSUM TABLE returns NULL and generates a warning. If the table does not meet all these conditions, the QUICK method ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order. Previously, indexes could be scanned in reverse order but at a performance penalty. A descending index can be ...
https://dev.mysql.com/doc/refman/8.4/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...