Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-column-names.html
Syntax: sequence = cursor.column_names This read-only property returns the column names of a result set as sequence of Unicode strings.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-backup-dashboard-details.html
Start LSN: InnoDB log sequence number at which the backup started. End LSN: InnoDB log sequence number at which the backup ended. Backup Command Displays the full path and parameters of the backup command which created the backup. The Backup ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in autocommit mode, the sequence starts over for all storage engines except InnoDB and MyISAM. In this case, reuse of values deleted from the top of the sequence ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
This might be zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. However, it might update zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. A ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. In the following example, the sequence of values produced by RAND(3) is the same ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
MRR iterates over a sequence of index ranges to obtain qualifying index tuples. The MRR optimization is not supported with secondary indexes created on virtual generated columns. Data rows are accessed according to the sorted index tuple sequence.
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
During the normal startup sequence, the server loads plugins registered in the table. The --plugin-load and --plugin-load-add options load plugins after built-in plugins and storage engines have initialized during the server startup sequence. For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The keyring service handles the creation, retrieval, and deletion of the binary log encryption keys. A server instance only creates and removes keys generated for itself, but it can read keys generated for other instances if they are stored in the ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
If the NO_BACKSLASH_ESCAPES SQL mode is enabled, the sequence cannot be empty. For example, consider the following table and data: CREATE TABLE foo (bar VARCHAR(10)); INSERT INTO foo VALUES (NULL), (NULL); The query SELECT COUNT(*) FROM foo WHERE ...