PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. The number increases each time the server creates a new log file, thus creating an ordered series of files. The server ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
Installing Loadable Functions Uninstalling Loadable Functions Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a loadable function manually, use the CREATE FUNCTION statement. For example: CREATE FUNCTION metaphon ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
MySQL Installer provides the following sequence of actions that apply to different workflows: Select Products. For example: It creates the configuration file (my.ini) that is used to configure the MySQL server. It can optionally create MySQL server ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...