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/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. Transaction 2 does not start until a transactional table is accessed, despite the intervening updates to nontransactional tables. To selectively examine transaction history, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-member-actions.html
By default, super read-only mode is disabled on the primary when it is elected, so that the primary becomes read-write, and accepts updates from a replication source server and from clients. If the server where you use the functions to configure a ... From MySQL 8.0.26, Group Replication has the capability to set actions for the members of a group to take in specified ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
However, in MySQL 8.0, you cannot switch from row-based or mixed format for binary logging to statement-based format at runtime, due to any CREATE TEMPORARY TABLE statements having been omitted from the binary log in the previous mode. The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multibyte safe and may produce unexpected results with multibyte character sets. Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
(For upgrades to an existing installation, perform the upgrade procedure instead; see Chapter 3, Upgrading MySQL.) However, the command that initializes the data directory does not overwrite any existing mysql schema tables, so it is safe to run in ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
To avoid connecting to untrusted servers, clients can establish a secure connection and verify the server identity by connecting using the --ssl-mode=VERIFY_IDENTITY option and the appropriate CA certificate. The utilities handle the file transfer ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
The replication_applier_status_by_worker table is nonempty only when the replica is operating in multithreaded mode. It refers to the master.info file used for the replica's source metadata repository, which has been superseded by the use of ...This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Also, a deletion is treated internally as an update ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
Running ndb_index_stat with the --update option causes sampleVersion to be incremented. To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the ...