Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
This section provides information about the NdbBlob class, which models a handle to a blob column and provides read and write access to blob column values. This object has a number of different states and provides several modes of access to blob ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password options. You can either create a new user with a limited set of privileges, or use an administrative account such as root. Here are ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-reset.html
reset [--sequential-restart] filter_specification_list cluster_name filter_specification_list: filter_specification[,filter_specification][,...] filter_specification: attribute_name[:process_specification][+process_specification]] ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
Once this is done, we modify the target cluster's configuration until it matches that of the wild cluster that we want to import. At a later point in the example, we also show how to test the configuration in a dry run before attempting to perform ...