Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-list.html
The app_task_status_list routine returns a paginated list of application task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status_list( IN 'app_user_id' VARCHAR(255), ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-list.html
The task_list routine returns a paginated list of asynchronous tasks. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_list( IN 'task_type' VARCHAR(80), IN offset INT UNSIGNED, IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-list.html
The task_status_list routine returns a paginated list of task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_status_list( IN 'task_type' VARCHAR(80), IN offset INT ...
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/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
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/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...