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/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
They do not apply to tables that are implicitly updated by the query. For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
However, because the file positions are not being regularly updated in the connection metadata repository and the applier metadata repository except in a few situations, they are likely to be out of date if the server is restarted. When the receiver ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. From MySQL 8.0, the system variables are also not modified when Group Replication is in single-primary ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. Repairing through the key buffer is used in the following cases: You use --safe-recover. The options described in this section can be ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Checklist: Enable strict SQL mode to tell the server to be more restrictive of what data values it accepts. Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on columns used in CHECK constraints. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates ... Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
While a transaction is open, the system keeps a snapshot of the data as seen at the beginning of the transaction, which can cause substantial overhead if the system inserts, updates, and deletes millions of rows while a stray transaction keeps ...