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/replication-asynchronous-connection-failover.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
For a replication connection, specifying a value for either of SOURCE_SSL_CA or SOURCE_SSL_CAPATH corresponds to setting --ssl-mode=VERIFY_CA. For a replication connection, specifying MASTER_SSL_VERIFY_SERVER_CERT=1 corresponds to setting ... To use ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
To get rid of the warning, execute an UPDATE statement to set the column to some value other than 0. CHECK TABLE Usage Notes for MyISAM Tables The following notes apply to MyISAM tables: CHECK TABLE updates key statistics for MyISAM tables. option: ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. If you have a problem with indexes not being used when ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
It became a bugfix series as of MySQL 8.0.34 with the introduction of the Innovation and LTS release model. For the syntax required to perform multiple-table updates, see Section 15.2.17, “UPDATE Statement”; for that required to perform ...Why ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. ON DUPLICATE KEY UPDATE statements, but if a duplicate-key ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html
0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ACTION. For related usage information and examples, see Section 17.15.3, ...